Table of Contents

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.

See also