TdxSpreadSheetFormulaController Class

A spreadsheet formula expression controller.

Declaration

TdxSpreadSheetFormulaController = class(
    TdxSpreadSheetCustomFormulaController
)

Remarks

A spreadsheet formula controller manages formula expression parsing and calculation in TdxSpreadSheet and TdxSpreadSheetReportDesigner controls.

Main API Members

The list below outlines key members of the TdxSpreadSheetFormulaController class. These members allow you to manage formula expression parsing and calculation processes.

ArrayFormulas: Provides access to all parsed array formula expressions in the current scope (worksheet or Grid View).
Calculate: Recalculates all formula expressions and updates all references.
CalculationInProcess: Indicates if a formula calculation is underway.
CircularReferencePaths |CircularReferencePathsAsString: Return circular references used in recursive calculations.
FormatSettings: Provides access to formula expression format settings (for parsing routines).
Items: Provides indexed access to all parsed formula expressions in the current scope (worksheet or Grid View).
SpreadSheet: Provides access to the parent control (TdxSpreadSheet or TdxSpreadSheetReportDesigner).
UpdateReferences: Updates cell references within the target area.