SpreadJS Documentation
CellRange type
GC.Spread.Sheets Namespace : CellRange type
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
 NameDescription
public ConstructorRepresents a cell range in a sheet.  
Top
Fields
 NameDescription
public FieldGets the starting column index.  
public FieldGets the column count.  
public FieldGets the starting row index.  
public FieldGets the row count.  
public FieldGets the sheet that contains this cell range.  
public FieldGets the area that contains this cell range.  
Top
Methods
 NameDescription
public MethodGets or sets the background color for the cell, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.  
public MethodGets or sets the background image for the cell.  
public MethodGets or sets the background image layout for the cell.  
public MethodGets or sets the binding path for cell binding.  
public MethodGets or sets the bottom border of the cell.  
public MethodGets or sets the left border of the cell.  
public MethodGets or sets the right border of the cell.  
public MethodGets or sets the top border of the cell.  
public MethodGets or sets the cell padding.  
public MethodGets or sets the cell type of the cell.  
public MethodClears the specified area.  
public MethodGets or sets the comment for the cell.  
public MethodGets or sets the diagonalDown of the cell.  
public MethodGets or sets the diagonalUp of the cell.  
public MethodGets or sets the font for the cell, such as "normal normal normal 20px/normal Arial".  
public MethodGets or sets the color of the text in the cell, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.  
public MethodGets or sets the formatter for the cell.  
public MethodGets or sets the formula for the cell.  
public MethodGets or sets the horizontal alignment of the contents of the cell.  
public MethodGets or sets the height of the row in pixels.  
public MethodGets or sets the imeMode of the cell.  
public MethodGets or sets whether the cell's text is vertical.  
public MethodGets or sets the cell label options.  
public MethodGets or sets whether the cell is locked. When the sheet is protected, the locked cell cannot be edited.  
public MethodGets or sets the quote Prefix the cell watermark.  
public MethodGets or sets whether the row or column can be resized by the user.  
public MethodSets the border for the specified area.  
public MethodGets or sets whether the cell shrinks the text to fit the cell size.  
public MethodGets or sets a value that indicates whether the user can set focus to the cell using the Tab key.  
public MethodGets or sets the tag for the cell.  
public MethodGets or sets the formatted text for the cell.  
public MethodGets or sets the type of the decoration added to the cell's text.  
public MethodGets or sets the text indent of the cell.  
public MethodGets or sets the theme font for the cell.  
public MethodGets or sets the data validator for the cell.  
public MethodGets or sets the vertical alignment of the contents of the cell.  
public MethodGets or sets the unformatted value of the cell.  
public MethodGets or sets whether the row or column is displayed.  
public MethodGets or sets the content of the cell watermark.  
public MethodGets or sets the width of the column in pixels.  
public MethodGets or sets whether the cell lets text wrap.  
Top
See Also

Reference

GC.Spread.Sheets Namespace