SpreadJS 14
GC.Spread.Sheets Namespace / Range type
In This Topic
    Range type
    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;
    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