Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetFormula Class

Stores a parsed formula expression within a cell object.

#Declaration

Delphi
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.

#Inheritance

See Also