CellRange Method

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".

Represents a cell range in a sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

var value; // Type: any
value = GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);

function CellRange( 
   sheet : Worksheet,
   row : number,
   col : number,
   rowCount : number,
   colCount : number,
   sheetArea : SheetArea
) : any;

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".

Reference

Sheets type