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