TFormulaValueType Enumeration
This enumeration contains the possible values a formula might contain.
Syntax
Unit: FlexCel.Core
Members
Name | Value | Description |
---|---|---|
Empty | 0 | The formula result is empty. |
Number | 1 | The formula contains a number. |
DateTime | 2 | The formula contains a TDateTime. |
StringValue | 3 | The formula contains a string. |
Boolean | 4 | The formula contains a boolean value. |
Error | 5 | The formula result is an error. |
MissingArg | 6 | This is used when a parameter for a function is missing like in the formula "=MyFunction(1, ,3). Normally it means the same as an empty value. |
CellAddress | 7 | The formula contains a single cell reference. |
CellRange | 8 | The formula contains a range of cells. |
Range3D | 9 | The formula contains TXls3DRange. |
Average | 10 | This is used internally when the formula is calculating an Average. The contents of the formula are of type TAverageValue. This is for internal use, final formula results won't be of this type when you are doing your own user defined functions. |
Lambda | 11 | The formula contains a lambda function. This is for internal use, final formula results won't be of this type when you are doing your own user defined functions. |