SpreadJS 13
GC.Spread.Sheets Namespace / CellRange type
In This Topic
    CellRange type
    In This Topic
    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 cellButtons 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 dropDowns 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 the cell ellipsis property.  
    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 text rotation angle 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