Edit this page

Telerik.Web.UI.SpreadsheetRange

Inheritance Hierarchy

Methods

clear

Clears the contents of the range cells.

Parameters

options? Object

Returns

None

clearFilter

Clears the set filters for the given column(s). The indices is relative to the beginning of the range.

Parameters

indices Array

Returns

None

fillFrom

Fills a range with values inferred from a source range. This method employs some heuristics similar to what Excel's auto-filling algorithm does when you select a range of cells and drag the bottom-right handle. The range to be filled is the current object, and you must pass a source range containing data as first argument.

Parameters

srcRange String
direction? Number

Returns

None

get_borderBottomColor

Gets the color of the bottom border of the cells.

Parameters

Returns

String

get_borderBottomSize

Gets the size of the bottom border of the cells.

Parameters

Returns

Number

get_borderLeftColor

Gets the color of the left border of the cells.

Parameters

Returns

String

get_borderLeftSize

Gets the size of the left border of the cells.

Parameters

Returns

Number

get_borderRightColor

Gets the color of the right border of the cells.

Parameters

Returns

String

get_borderRightSize

Gets the size of the right border of the cells.

Parameters

Returns

Number

get_borderTopColor

Gets the color of the top border of the cells.

Parameters

Returns

String

get_borderTopSize

Gets the size of the top border of the cells.

Parameters

Returns

None

get_enabled

Gets the disabled state of the cells in the range.

Parameters

Returns

Boolean

get_isFilterable

Returns true if a range can be filtered.

Parameters

Returns

Boolean

get_isSortable

Returns true if a range can be sorted.

Parameters

Returns

Boolean

hasFilter

Returns true if the sheet of the range has filter enabled.

Parameters

Returns

Boolean

merge

Merges the range cells into a single merged cell. If the range already includes a merged cell, they are merged, too.

Parameters

Returns

None

select

Sets the sheet selection to the range cells.

Parameters

Returns

None

set_borderBottomColor

Sets the color of the bottom border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The color may be set to any valid CSS color.

Parameters

color String

Returns

None

set_borderBottomSize

Sets the size of the bottom border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The method accepts any valid Length value.

Parameters

size Number

Returns

None

set_borderLeftColor

Sets the color of the left border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The color may be set to any valid CSS color.

Parameters

color String

Returns

None

set_borderLeftSize

Sets the size of the left border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The method accepts any valid Length value.

Parameters

size Number

Returns

None

set_borderRightColor

Sets the color of the right border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The color may be set to any valid CSS color.

Parameters

color String

Returns

None

set_borderRightSize

Sets the size of the right border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The method accepts any valid Length value.

Parameters

size Number

Returns

None

set_borderTopColor

Sets the color of the top border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The color may be set to any valid CSS color.

Parameters

color String

Returns

None

set_borderTopSize

Sets the size of the top border of the cells. If the range includes more than a single cell, the setting is applied to all cells. The method accepts any valid Length value.

Parameters

size String

Returns

None

set_enabled

Sets the disabled state of the cells in the range.

Parameters

value Boolean

Returns

None

set_filter

Enables/disables or sets the filter for a given range.

Parameters

filter Object

Returns

None

unmerge

Un-merges any merged cells which are included in the range.

Parameters

Returns

None