Range Constructor

SpreadJS Documentation

Range Constructor

Collapse All

GcSpread.Sheets Namespace > Range type : Range Constructor

The row index.

The column index.

The row count.

The column count.

Represents a range, which is described by the row index, column index, row count, and column count.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Range(r, c, rc, cc);

function Range( 
   r : number,
   c : number,
   rc : number,
   cc : number
) : Range;

Parameters

r: The row index.
c: The column index.
rc: The row count.
cc: The column count.

Example

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.CellValueRule(GcSpread.Sheets.ComparisonOperator.Between,2,100,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,5,1)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);

Reference

Range type

Send comments on this topic.