TFormula Record
An Excel formula. Use this class to pass a formula to an Excel sheet.
Syntax
Unit: FlexCel.Core
TFormula = record;Fields
| Name | Description |
|---|---|
| Span | For multicell formulas (like an array formula entered over more than one cell) this property says how many rows and columns the formula uses. Normal formulas will span one single cell |
Methods
| Name | Description |
|---|---|
| Create | Overloaded Create Create(string) Create(string, TSingleFormulaValue) Create(string, TSingleFormulaValue, TFormulaSpan) |
| Null | Creates an undefined Excel formula |
| ToString | Returns the formula result as a string. |
| Equals | Returns true if obj is equal to this instance. |
| GetHashCode | Hashcode of the formula. |
| IsNull | Returns true if the record doesn't have a defined value. |
| HasValue | Returns true if the record has a defined value. This is the inverse of IsNull |
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 |
|---|---|
| Text | The formula text, as it is written on Excel. It must begin with "=" or "{" for array formulas. |
| FormulaResult | The formula result. |