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