Class $.wijmo.wijspread.Range

Class Summary
Constructor Attributes	Constructor Name and Description
	$.wijmo.wijspread.Range(r, c, rc, cc) Represents a range, which is described by the row index, column index, row count, and column count.

Method Summary
Method Attributes	Method Name and Description
	contains(row, col, rowCount, colCount) Gets whether the current range contains the specified cell.
	containsRange(range) Gets whether the current range contains the specified range.
	equals(range) Gets whether the current range is equal to the specified range.
	intersect(row, col, rowCount, colCount) Gets whether the current range intersects with the one specified by the row and column index and the row and column count.
	offset(x, y, range) Offsets the location of the range by the specified coordinates.
	union(range) Joins this range with the specified range as a union.

Class Detail

$.wijmo.wijspread.Range(r, c, rc, cc)

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

var style = new $.wijmo.wijspread.Style();
style.backColor = "red";
var rule = new $.wijmo.wijspread.CellValueRule($.wijmo.wijspread.ComparisonOperator.Between,2,100,style);
rule.ranges=[new $.wijmo.wijspread.Range(0,0,5,1)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);

Parameters:
{number} r: The row index.
{number} c: The column index.
{number} rc: The row count.
{number} cc: The column count.

Method Detail

{boolean} contains(row, col, rowCount, colCount)

Gets whether the current range contains the specified cell.

Parameters:
{number} row: The row index.
{number} col: The column index.
{number} rowCount: The row count.
{number} colCount: The column count.

Returns:: {boolean} true if the range contains the cell; otherwise, false.

{boolean} containsRange(range)

Gets whether the current range contains the specified range.

Parameters:
range: The cell range.

Returns:: {boolean} true if the current range contains the specified cell range; otherwise, false.

equals(range)

Gets whether the current range is equal to the specified range.

Parameters:
{Range} range: The range to compare.

{boolean} intersect(row, col, rowCount, colCount)

Gets whether the current range intersects with the one specified by the row and column index and the row and column count.

Parameters:
{number} row: The row index.
{number} col: The column index.
{number} rowCount: The row count.
{number} colCount: The column count.

Returns:: {boolean} true if the specified range intersects with the current range; otherwise false.

offset(x, y, range)

Offsets the location of the range by the specified coordinates.

Parameters:
x: The offset along the x-axis.
y: The offset along the y-axis.
range: The new location.

{Range} union(range)

Joins this range with the specified range as a union.

Parameters:
{Range} range: The target range.

Returns:: {Range} Returns the union of the ranges.

Classes

Class $.wijmo.wijspread.Range