Setting the Calculation Mode for a Workbook

The CalculationMode property specifies the calculation mode for all formulas in the workbook. The CalculationMode enumeration provides three options: Manual (you manually perform the calculation), Auto (the calculation is automatically performed), or AutoNoTable (the calculation is performed except on tables).

To set the calculation mode, follow these steps:

Add a reference to C1.WPF.Excel.dll or C1.Silverlight.Excel.dll and create a C1XLBook.

C#	Copy Code
// Create a new workbook C1XLBook book = new C1XLBook();

Add a simple formula using the following code:

C#	Copy Code
XLSheet sheet = book.Sheets[0]; // simple formula sheet[7, 0].Value = "Formula: 5!"; sheet[7, 1].Value = 122; sheet[7, 1].Formula = "12345"; book.CalculationMode = CalculationMode.Auto;

Save and open the .xlsx file.

C#	Copy Code
// Save and open the file book.Save(@"C:\test.xlsx"); System.Diagnostics.Process.Start(@"C:\test.xlsx");

Notice that the value for the cell in (7,1) is 120, or the total of 1*2*3*4*5, not 122, since we set the CalculationMode to Auto.