TdxSpreadSheetFormula Class
Stores a parsed formula expression within a cell object.
Declaration
TdxSpreadSheetFormula = class(
TdxSpreadSheetCustomFormula
)Remarks
This class implements Microsoft Excel-style formula expressions in the Spreadsheet and Report Designer controls.
The TdxSpreadSheetFormula class provides the following members that allow you to:
Identify the cell and worksheet to which the formula expression belongs (Cell, AnchorColumn, AnchorRow, and View);
Identify the formula evaluation or calculation error (ErrorCode and ErrorIndex);
Access the controller that handles the formula expression (Controller);
Obtain the parsed formula expression’s source text string (AsText and SourceText);
Access the parsed formula expression’s tokens (Tokens);
Copy the TdxSpreadSheetFormula object for use in another cell (Clone);
Switch the formula expression calculation between the array and single value result modes (IsArrayFormula);
Obtain the rectangular cell range occupied by the calculated array result (ArrayFormulaArea and ArrayFormulaSize);
Extract the cell ranges to which the formula expression is referring (EnumReferences);
Obtain the formula expression calculation result (Value).
The TdxSpreadSheetCell.AsFormula and TdxSpreadSheetFormulaController.Items properties reference a TdxSpreadSheetFormula object.