Spread.Sheets Documentation
Range Constructor
GC.Spread.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
var instance = new GC.Spread.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
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);
See Also

Reference

Range type

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.