SpreadJS 14
GC.Spread.Sheets Namespace / Range type / Range Constructor
The row index.
The column index.
The row count.
The column count.
In This Topic
    Range Constructor
    In This Topic
    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