GrapeCity.Documents.Excel.CalculationMode

CalculationMode Enum

Specifies the calculation mode used by Microsoft Excel when the exported workbook is opened.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum CalculationMode

Public Enum CalculationMode

Examples

Workbook workbook = new Workbook();
workbook.ActiveSheet.Range["A1"].Formula = "SUM(1, 2)";
workbook.Options.Formulas.CalculationMode = CalculationMode.Manual;
workbook.Save("path/to/manual-mode.xlsx");

Fields

Name	Description
Automatic	Automatic recalculation. Recalculate whenever something is changed, and every time a workbook is opened.
Manual	Manual calculation mode.
Semiautomatic	Semiautomatic recalculation. It automatically recalculates everything except for Data Tables and Python formulas.