FormulaSettings.CalculationMode

FormulaSettings.CalculationMode property

Gets or sets the mode for workbook calculation in ms excel.

public CalcModeType CalculationMode { get; set; }

Remarks

This property is only for saving the settings to resultant spreadsheet file so that other applications(such as ms excel) may act accordingly when loading and manipulating the resultant file. For performance consideration for most user’s application, we do not calculate any formula in the workbook automatically, no matter what mode has been set for this property. If user needs to calculate formulas, please always call methods on different objects according to requirement: CalculateFormula, CalculateFormula, Calculate, …etc.

See Also