var instance = new GC.Spread.Sheets.Range(r, c, rc, cc);
function Range;
var instance = new GC.Spread.Sheets.Range(r, c, rc, cc);
function Range;
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);
Object
GC.Spread.Sheets.Range
Name | Description | |
---|---|---|
![]() | Range Constructor | Represents a range, which is described by the row index, column index, row count, and column count. |
Name | Description | |
---|---|---|
![]() | col | The column index. |
![]() | colCount | The column count. |
![]() | row | The row index. |
![]() | rowCount | The row count. |
Name | Description | |
---|---|---|
![]() | contains | Gets whether the current range contains the specified cell. |
![]() | containsRange | Gets whether the current range contains the specified range. |
![]() | equals | Gets whether the current range is equal to the specified range. |
![]() | getIntersect | Gets the intersection of two cell ranges. |
![]() | intersect | Gets whether the current range intersects with the one specified by the row and column index and the row and column count. |
![]() | offset | Offsets the location of the range by the specified coordinates. |
![]() | union | Joins this range with the specified range as a union. |