SpreadJS 13
GC.Spread.Sheets Namespace / CellRange type / CellRange Constructor
The sheet that contains this cell range.
The row index of the cell.
The column index of the cell.
The row count of the cell. If you do not provide this parameter, it defaults to 1.
The column count of the cell. If you do not provide this parameter, it defaults to 1.
The sheet area. If you do not provide this parameter, it defaults to viewport. If row is -1 and rowCount is -1, the range represents columns. For example, new GC.Spread.Sheets.CellRange(-1,4,-1,6) represents columns "E:J". If col is -1 and colCount is -1, the range represents rows. For example, new GC.Spread.Sheets.CellRange(4,-1,6,-1) represents rows "5:10".
In This Topic
    CellRange Constructor
    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( 
       sheet : Worksheet,
       row : number,
       col : number,
       (optional) rowCount : number,
       (optional) colCount : number,
       (optional) sheetArea : SheetArea
    ) : CellRange;

    Parameters

    sheet
    The sheet that contains this cell range.
    row
    The row index of the cell.
    col
    The column index of the cell.
    rowCount
    The row count of the cell. If you do not provide this parameter, it defaults to 1.
    colCount
    The column count of the cell. If you do not provide this parameter, it defaults to 1.
    sheetArea
    The sheet area. If you do not provide this parameter, it defaults to viewport. If row is -1 and rowCount is -1, the range represents columns. For example, new GC.Spread.Sheets.CellRange(-1,4,-1,6) represents columns "E:J". If col is -1 and colCount is -1, the range represents rows. For example, new GC.Spread.Sheets.CellRange(4,-1,6,-1) represents rows "5:10".
    See Also

    Reference

    CellRange type