TXls3DRange Record
A 3d Excel range.
Syntax
Unit: FlexCel.Core
TXls3DRange = record;Fields
| Name | Description |
|---|---|
| HasValue | False if the record doesn't have a defined value. When this field is false, the values of the other fields don't matter. |
| FileName | Filename if the range is in a different file. |
| Top | Top of the range. |
| Left | Left of the range. |
| Bottom | Bottom of the range. |
| Right | Right of the range. |
| Sheet2 | Second sheet of the range. |
Methods
| Name | Description |
|---|---|
| Create | Overloaded Create Create(TCoreExcelFile, string) Create(Integer, Integer, Integer, Integer, Integer, Integer) Create(string, Integer, Integer, Integer, Integer, Integer, Integer) |
| SetRange3DRef | Sets the value of the 3d range based on the string that defines the range in A1 notation. |
| TrySetRange3DRef | Tries to set the value of the 3d range based on the string that defines the range in A1 notation. If the name can't be set, no data is modified and this method returns false. |
| Null | Creates a null range. |
| Equals | Returns true if both objects are equal. |
| GetHashCode | Returns the hashcode of the object. |
| 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. |