ExcelCalcMode Enumeration

Office Open XML

How the application should calculate formulas in the workbook

Namespace:  OfficeOpenXml
Assembly:  EPPlus (in EPPlus.dll) Version: 3.0.0.1 (3.0.0.1)

Syntax

C#
public enum ExcelCalcMode
Visual Basic (Declaration)
Public Enumeration ExcelCalcMode
Visual C++
public enum class ExcelCalcMode

Members

Member nameDescription
Automatic
Indicates that calculations in the workbook are performed automatically when cell values change. The application recalculates those cells that are dependent on other cells that contain changed values. This mode of calculation helps to avoid unnecessary calculations.
AutomaticNoTable
Indicates tables be excluded during automatic calculation
Manual
Indicates that calculations in the workbook be triggered manually by the user.

See Also