TXlsFile.RecalcMode Property

Set this property to change how the file will be recalculated. Note that this affects only how FlexCel recalculates the file, but not how Excel will recalculate it. It doesn't change anything in the generated file. To change the options for the file, use TExcelFile.OptionsRecalcMode instead.

Remarks

Setting RecalcMode = Manual might be a little faster for big spreadsheets with *lots* of formulas, but they won't preview ok on Excel viewers as FlexCelPrintDocument. See also TExcelFile.RecalcVersion When Manual, you can still call TExcelFile.Recalc(Boolean) with "forced" = true to recalculate the sheet.

Not all functions are supported, those that are not will return a #NAME? error on a viewer, and will be recalculated by Excel when you open the file. See Supported Excel Functions for a list of supported functions.

Syntax

Unit: FlexCel.XlsAdapter

property TXlsFile.RecalcMode: TRecalcMode

See also

• TXlsFile