New to Telerik Document Processing? Start a free 30-day trial

CellReferenceRange

Class

Represents a rectangular range of cell references with absolute or relative addressing, used in formulas to reference contiguous cell areas.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class CellReferenceRange

Inheritance: objectCellReferenceRange

Methods

Equals(object)

bool

Determines whether the specified object is equal to the current object.

public override bool Equals(object obj)

Parameters:objobject

The object to compare with the current object.

Returns:

bool

True if the specified object is equal to the current object; otherwise, false.

Overrides: object.Equals(object)

GetHashCode()

int

Serves as a hash function for a particular type.

public override int GetHashCode()

Returns:

int

A hash code for the current object.

Overrides: object.GetHashCode()

ToString()

string

Returns a string that represents the current object.

public override string ToString()

Returns:

string

A string that represents the current object.

Overrides: object.ToString()

Properties

ColumnsCount

int

Gets the number of columns spanned by the reference range.

public int ColumnsCount { get; }

Property Value:

The columns count.

FromCellReference

CellReference

Gets the top-left cell reference of the range.

public CellReference FromCellReference { get; }

Property Value:

The start cell reference.

IsInRange

bool

Gets whether the reference range lies within valid worksheet boundaries.

public bool IsInRange { get; }

Property Value:

The value indicating whether the range is within the valid boundaries.

RowsCount

int

Gets the number of rows spanned by the reference range.

public int RowsCount { get; }

Property Value:

The rows count.

ToCellReference

CellReference

Gets the bottom-right cell reference of the range.

public CellReference ToCellReference { get; }

Property Value:

The end cell reference.

Worksheet

Gets the worksheet to which this cell reference range belongs.

public Worksheet Worksheet { get; }

Property Value:

The worksheet.

Extension Methods

ExpressionExtensions.ToCellRange(CellReferenceRange)