TExcelFile.Recalc Method
Overloads
TExcelFile.Recalc
When RecalcMode is manual, use this method to force a recalculation of the spreadsheet. This specific version of the method will always perform a recalc, even if it is not needed. You can use Recalc(Boolean) to recalc only when is needed.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.Recalc; overload;See also
TExcelFile.Recalc(Boolean)
When RecalcMode is manual, use this method to force a recalculation of the spreadsheet.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.Recalc(const forced: Boolean); overload; virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | forced | Boolean | When true this method will always perform a recalc. When false, only if there has been a change on the spreadsheet. While for performance reasons you will normally want to keep this false, you might need to set it to true if the formulas refer to functions like "=NOW()" or "=RANDOM()" that change every time you recalculate. |