Range type

Represents a range, which is described by the row index, column index, row count, and column count.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Range(r, c, rc, cc);

function Range;

Example

Javascript

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

	Name	Description
	Range Constructor	Represents a range, which is described by the row index, column index, row count, and column count.

Top

Fields

	Name	Description
	col	The column index.
	colCount	The column count.
	row	The row index.
	rowCount	The row count.

Top

Methods

	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.

Top

Reference

GC.Spread.Sheets Namespace