TdxSpreadSheetFormula Members
Stores a parsed formula expression within a cell object.Constructors
| Name | Description |
|---|---|
| Create(TdxSpreadSheetCell) | Creates a formula expression in the specified cell object. |
Properties
| Name | Description |
|---|---|
| ActualErrorCode | Inherited from TdxSpreadSheetCustomFormula. |
| ActualValue | Returns the formula expression’s calculation result. Inherited from TdxSpreadSheetCustomFormula. |
| Anchor | Returns the coordinates of the formula expression’s anchor cell. Inherited from TdxSpreadSheetCustomFormula. |
| AnchorColumn | Returns a zero-based index of the column to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula. |
| AnchorRow | Returns the zero-based index of the row to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula. |
| ArrayFormulaArea | Returns the area occupied by the array formula result. Inherited from TdxSpreadSheetCustomFormula. |
| ArrayFormulaSize | Returns the dimensions (in cells) of an area occupied the array formula result. Inherited from TdxSpreadSheetCustomFormula. |
| AsText | Returns the parsed formula expression as a text string. Inherited from TdxSpreadSheetCustomFormula. |
| Cell | Returns the cell object to which the formula belongs. |
| Controller | Provides access to the formula controller that handles the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula. |
| ErrorCode | Returns an error code indicating the parsed formula expression’s evaluation or calculation state. Inherited from TdxSpreadSheetCustomFormula. |
| ErrorIndex | Returns the index of the first unrecognized character in the formula expression’s source text. Inherited from TdxSpreadSheetCustomFormula. |
| FormatSettings | Provides access to the formula expression’s source text string parsing format settings. Inherited from TdxSpreadSheetCustomFormula. |
| IsArrayFormula | Specifies if the formula expression’s calculation result is an array. Inherited from TdxSpreadSheetCustomFormula. |
| Iteration | Inherited from TdxSpreadSheetCustomFormula. |
| ResultValue | Provides access to the properties and methods related to parsing the formula expression’s source text. Inherited from TdxSpreadSheetCustomFormula. |
| SourceText | Specifies the source text string of the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula. |
| Tokens | Provides access to the token tree of the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula. |
| Value | Returns the formula expression’s calculation result. Inherited from TdxSpreadSheetCustomFormula. |
| View | Provides access to the worksheet or Grid View to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula. |
Methods
| Name | Description |
|---|---|
| Clone | Returns a copy of the formula expression object. |
| EnumReferences(TdxSpreadSheetFormulaEnumReferencesProc,Boolean) | Inherited from TdxSpreadSheetCustomFormula. |
| EnumReferences(TdxSpreadSheetFormulaEnumReferenceTokensProc,Boolean) | Enumerates references in the formula expression. Inherited from TdxSpreadSheetCustomFormula. |
| Equals(TObject) | Inherited from TObject. |
| GetHashCode | Inherited from TObject. |
| ToString | Inherited from TObject. |
| Validate | Checks if the parsed formula expression is correct. Inherited from TdxSpreadSheetCustomFormula. |
See Also