SpreadJS Documentation
Range type
GC.Spread.Sheets Namespace : Range type
Represents a range, which is described by the row index, column index, row count, and column count.
Syntax
var instance = new GC.Spread.Sheets.Range(r, c, rc, cc);
function Range;
Example
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
rule.ranges([new GC.Spread.Sheets.Range(0,0,5,1)]);
rule.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between);
rule.style(style);
rule.value1(2);
rule.value2(100);
activeSheet.conditionalFormats.addRule(rule);
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,45,3);
Inheritance Hierarchy

Object
   GC.Spread.Sheets.Range

Constructors
 NameDescription
public ConstructorRepresents a range, which is described by the row index, column index, row count, and column count.  
Top
Fields
 NameDescription
public FieldThe column index.  
public FieldThe column count.  
public FieldThe row index.  
public FieldThe row count.  
Top
Methods
 NameDescription
public MethodGets whether the current range contains the specified cell.  
public MethodGets whether the current range contains the specified range.  
public MethodGets whether the current range is equal to the specified range.  
public MethodGets the intersection of two cell ranges.  
public MethodGets whether the current range intersects with the one specified by the row and column index and the row and column count.  
public MethodOffsets the location of the range by the specified coordinates.  
public MethodJoins this range with the specified range as a union.  
Top
See Also

Reference

GC.Spread.Sheets Namespace