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

TdxSpreadSheetCustomFormulaController.Calculate Method

In This Article

Calculates all formula expressions managed by the current formula controller.

#Declaration

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

See Also