GC.Spread.Sheets Namespace : CellRange type |
var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
function CellRange;
Object
GC.Spread.Sheets.CellRange
Name | Description | |
---|---|---|
![]() | CellRange Constructor | Represents a cell range in a sheet. |
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. |
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. |