This structure is used in formulas that span more than one cell, like some array formulas, or "what-if" table formulas.
Syntax
Unit: FlexCel.Core
TFormulaSpan = record;
Methods
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 |
| RowSpan |
How many rows the formula will use.
|
| ColSpan |
How many columns the formula will use.
|
| IsTopLeft |
Indicates if this is the first formula of the array. Only the formula that is at the top left cell of the group will be used when setting a formula. Other formulas will be ignored, so you can copy formulas in a loop from one place to the other without worring if the cell is at the top left or not.
|
| IsOneCell |
Returns true if this formula spans over a single cell. (the most usual case) |