Table of Contents

TXlsCellRange Record

An Excel Cell range, 1-based.

Syntax

Unit: FlexCel.Core

TXlsCellRange = record;

Fields

Name Description
HasValue False if the record doesn't have a defined value. When this field is false, the values of left, right, top and bottom don't matter.
Top First row on range.
Left First column on range.
Bottom Last row on range.
Right Last column on range.

Methods

Name Description
Intersects Returns true if this range intersects with another.
Create Overloaded
Create
Create(string)
Create(Integer, Integer, Integer, Integer)
Null Creates an invalid Cell range with the IsNull field set.
FullRange Creates a range with all cells on the sheet (65536 rows x 256 columns in Excel 97-2003)
Transpose Returns the range transposed, rows by columns.
Offset Creates a new range with the start at newTopRow, newLeftCol.
HasRow True if the specified row is in the range
HasCol True if the specified column is in the range
CalcTopCell Returns the minimum top and left coordinates for an array of ranges. If for example you have C7 and D5, this method will return C5
Dec Returns a COPY of the range decremented by one.
Inc Returns a COPY of the range incremented by one.
Equals Returns true if both objects are equal.
GetHashCode Returns the hashcode of the object.
Contains Returns true if the cell is inside the range.
ToString A human-readable representation of the range.
IsNull Returns true if the record doesn't have a defined value. This is the inverse of HasValue

Operators

Name Description
Equality Adapts the = operator so it returns true when both instances have the same values.
Inequality Adapts the <> operator so it returns true when both instances have different values.

Properties

Name Description
IsOneCell Returns true if the range has only one cell.
RowCount Number of rows on the range.
ColCount Number of columns on the range.
CellRef Gets or sets the string that defines the 2D-range in A1 notation.