Setting Formula Calculation Mode of Workbook in Aspose.Cells

Microsoft Excel allows you to set the formula calculation mode, that is, the way formulas are calculated. There are three possible values:

• Automatic – recalculate whenever something is changed, and every time a workbook is opened.
• Automatic except for data tables – recalculate whenever something is changed, but leaving out data tables.
• Manual – recalculate only when the user explicitly requests it by pressing F9 or CTRL+ALT+F9, or when the workbook is saved.

To set the formula calculation mode in Microsoft Excel:

1. Select Formulas and then Calculation Options.
2. Select one of the options.

Aspose.Cells also allows you to set the Formula Calculation Mode using the FormulaSettings.CalculationMode property. You can assign it a value from the CalcModeType enumeration, which has one of the following values:

• CalcModeType.Automatic
• CalcModeType.AutomaticExceptTable
• CalcModeType.Manual

The following sample code first creates a workbook, then sets the formula calculation mode to Manual, and saves the workbook as an output Excel file on disk.

C#

string FilePath = @"..\..\..\Sample Files\";
string FileName = FilePath + "Setting Formula Calculation Mode.xlsx";

// Create a workbook
Workbook workbook = new Workbook();

// Set the Formula Calculation Mode to Manual
workbook.Settings.FormulaSettings.CalculationMode = CalcModeType.Manual;

// Save the workbook
workbook.Save(FileName, SaveFormat.Xlsx);

Download Sample Code

• GitHub

Download Running Example

• GitHub