TdxSpreadSheetCustomFormulaController.Calculate Method

Calculates all formula expressions managed by the current formula controller.

Declaration

procedure Calculate; virtual;

Remarks

Call this procedure to calculate or recalculate the results of all formula expressions within a spreadsheet document or Grid View. The Calculate procedure is invoked automatically every time a parsed formula expression changes within the controller.

To calculate formula expressions within a spreadsheet document opened in a Spreadsheet or Report Designer control whose OptionsBehavior.AutomaticCalculation property is set to False, you can call the Calculate procedure or press F9.

Note

The CalculationInProcess property returns True while the Calculate procedure is updating all formula expression results within the controller.