ExcelFile.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 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 RecalcVersion When Manual, you can still call 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

Namespace: FlexCel.Core

public abstract TRecalcMode RecalcMode { get; set; }