TdxSpreadSheetFormulaController.Calculate Method
Calculates all formula expressions in the opened spreadsheet document.
Declaration
procedure Calculate; override;
Remarks
Call this procedure to calculate or recalculate the results of all formula expressions within a spreadsheet document opened in a Spreadsheet or Report Designer control. The Caculate procedure is invoked automatically every time a parsed formula expression changes within the controller, provided that the control’s OptionsBehavior.AutomaticCalculation property is set to True
.
Calling the Calculate
procedure is the only way to calculate formula results if the control’s automatic formula calculation functionality is disabled. End-users can force formula recalculation by pressing the F9 key.
Note
The CalculationInProcess property returns True
while the Calculate
procedure is working; otherwise, False
.