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