Search Results for

    Show / Hide Table of Contents

    TExcelFile.ConvertFormulasToValues Method

    Overloads

    • TExcelFile.ConvertFormulasToValues(Boolean)
    • TExcelFile.ConvertFormulasToValues(Boolean, Boolean)

    TExcelFile.ConvertFormulasToValues(Boolean)

    Use it to convert formulas to their values. It can be useful if for example you are copying the sheet to another workbook, and you don't want any references to it. NOTE: You will probably want to use ConvertExternalNamesToRefErrors(Boolean) too, to convert named ranges besides the formulas.

    Also note that if you want to convert a whole file, you need to call ConvertFormulasToValues in every sheet.

    Syntax

    Unit: FlexCel.Core

    procedure TExcelFile.ConvertFormulasToValues(const onlyExternal: Boolean); overload;

    Parameters

    <-> Parameter Type Description
    const onlyExternal Boolean When true, it will only convert the formulas that do not refer to the same sheet.
    For example "=A1+Sheet2!A1" will be converted, but "=A2+A3" will not.

    See also

    • TExcelFile

    TExcelFile.ConvertFormulasToValues(Boolean, Boolean)

    Use it to convert formulas to their values. It can be useful if for example you are copying the sheet to another workbook, and you don't want any references to it. NOTE: You will probably want to use ConvertExternalNamesToRefErrors(Boolean) too, to convert named ranges besides the formulas.

    Also note that if you want to convert a whole file, you need to call ConvertFormulasToValues in every sheet.

    Syntax

    Unit: FlexCel.Core

    procedure TExcelFile.ConvertFormulasToValues(const onlyExternal: Boolean; const recalcBeforeConverting: Boolean); overload; virtual; abstract;

    Parameters

    <-> Parameter Type Description
    const onlyExternal Boolean When true, it will only convert the formulas that do not refer to the same sheet.
    For example "=A1+Sheet2!A1" will be converted, but "=A2+A3" will not.
    const recalcBeforeConverting Boolean If true (the default), FlexCel will try to recalculate the file before converting the formulas.
    Use false when for any reason FlexCel can't recalculate the values (for example if you have links to other files that don't exist anymore)

    See also

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