Represents a cell range in a sheet.
Syntax
var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
function CellRange;
Inheritance Hierarchy
Object
GC.Spread.Sheets.CellRange
Constructors
| Name | Description | |
|---|---|---|
 | CellRange Constructor | Represents a cell range in a sheet. |
Fields
| Name | Description | |
|---|---|---|
 | col | Gets the starting column index. |
| colCount | Gets the column count. |
| row | Gets the starting row index. |
| rowCount | Gets the row count. |
| sheet | Gets the sheet that contains this cell range. |
| sheetArea | Gets the area that contains this cell range. |
Methods
| Name | Description | |
|---|---|---|
 | backColor | Gets or sets the background color for the cell, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on. |
| backgroundImage | Gets or sets the background image for the cell. |
| backgroundImageLayout | Gets or sets the background image layout for the cell. |
| bindingPath | Gets or sets the binding path for cell binding. |
| borderBottom | Gets or sets the bottom border of the cell. |
| borderLeft | Gets or sets the left border of the cell. |
| borderRight | Gets or sets the right border of the cell. |
| borderTop | Gets or sets the top border of the cell. |
| cellPadding | Gets or sets the cell padding. |
| cellType | Gets or sets the cell type of the cell. |
| clear | Clears the specified area. |
| comment | Gets or sets the comment for the cell. |
| font | Gets or sets the font for the cell, such as "normal normal normal 20px/normal Arial". |
| foreColor | Gets or sets the color of the text in the cell, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on. |
| formatter | Gets or sets the formatter for the cell. |
| formula | Gets or sets the formula for the cell. |
| hAlign | Gets or sets the horizontal alignment of the contents of the cell. |
| height | Gets or sets the height of the row in pixels. |
| imeMode | Gets or sets the imeMode of the cell. |
| labelOptions | Gets or sets the cell label options. |
| locked | Gets or sets whether the cell is locked. When the sheet is protected, the locked cell cannot be edited. |
| resizable | Gets or sets whether the row or column can be resized by the user. |
| setBorder | Sets the border for the specified area. |
| shrinkToFit | Gets or sets whether the cell shrinks the text to fit the cell size. |
| tabStop | Gets or sets a value that indicates whether the user can set focus to the cell using the Tab key. |
| tag | Gets or sets the tag for the cell. |
| text | Gets or sets the formatted text for the cell. |
| textDecoration | Gets or sets the type of the decoration added to the cell's text. |
| textIndent | Gets or sets the text indent of the cell. |
| themeFont | Gets or sets the theme font for the cell. |
| validator | Gets or sets the data validator for the cell. |
| vAlign | Gets or sets the vertical alignment of the contents of the cell. |
| value | Gets or sets the unformatted value of the cell. |
| visible | Gets or sets whether the row or column is displayed. |
| watermark | Gets or sets the content of the cell watermark. |
| width | Gets or sets the width of the column in pixels. |
| wordWrap | Gets or sets whether the cell lets text wrap. |
See Also