TFormulaSpan Record
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
| Name | Description |
|---|---|
| Create | Overloaded Create Create(Integer, Integer, Boolean) |
| Equals | Returns true of the 2 FormulaSpans are the same. |
| GetHashCode | Returns the hashcode for this object. |
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) |