Definition
Namespace:Telerik.Web.UI
Inheritance: Telerik.Web.UI.SpreadsheetRange
Methods
Clears the contents of the range cells.
clear(Object options): voidClears the set filters for the given column(s). The indices is relative to the beginning of the range.
clearFilter(Array indices): voidFills 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.
fillFrom(String srcRange, Number direction): voidGets the color of the bottom border of the cells.
get_borderBottomColor(): StringString
Gets the size of the bottom border of the cells.
get_borderBottomSize(): NumberNumber
Gets the color of the left border of the cells.
get_borderLeftColor(): StringString
Gets the size of the left border of the cells.
get_borderLeftSize(): NumberNumber
Gets the color of the right border of the cells.
get_borderRightColor(): StringString
Gets the size of the right border of the cells.
get_borderRightSize(): NumberNumber
Gets the color of the top border of the cells.
get_borderTopColor(): StringString
Gets the size of the top border of the cells.
get_borderTopSize(): voidGets the disabled state of the cells in the range.
get_enabled(): BooleanBoolean
Returns true if a range can be filtered.
get_isFilterable(): BooleanBoolean
Returns true if a range can be sorted.
get_isSortable(): BooleanBoolean
Returns true if the sheet of the range has filter enabled.
hasFilter(): BooleanBoolean
Merges the range cells into a single merged cell. If the range already includes a merged cell, they are merged, too.
merge(): voidSets the sheet selection to the range cells.
select(): voidSets 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.
set_borderBottomColor(String color): voidSets 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.
set_borderBottomSize(Number size): voidSets 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.
set_borderLeftColor(String color): voidSets 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.
set_borderLeftSize(Number size): voidSets 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.
set_borderRightColor(String color): voidSets 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.
set_borderRightSize(Number size): voidSets 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.
set_borderTopColor(String color): voidSets 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.
set_borderTopSize(String size): voidSets the disabled state of the cells in the range.
set_enabled(Boolean value): voidEnables/disables or sets the filter for a given range.
set_filter(Object filter): voidUn-merges any merged cells which are included in the range.
unmerge(): void