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.
|