var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
function CellRange;
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. | |
diagonalDown | Gets or sets the diagonalDown of the cell. | |
diagonalUp | Gets or sets the diagonalUp of 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. | |
isVerticalText | Gets or sets whether the cell's text is vertical. | |
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. | |
quotePrefix | Gets or sets the quote Prefix the cell watermark. | |
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. |