Search Results for

    Show / Hide Table of Contents

    TExcelFile.Recalc Method

    Overloads

    • TExcelFile.Recalc
    • TExcelFile.Recalc(Boolean)

    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

    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

    • TExcelFile
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com