TXlsFile.Recalc Method
When TExcelFile.RecalcMode is manual, use this method to force a recalculation of the spreadsheet.
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.Recalc(const forced: Boolean); overload; override;
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. |