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:

  1. Double-click the C1XLBook component in the Toolbox to add it to your form.
  2. Add a simple formula using the following code:

    To write code in Visual Basic

    Visual Basic
    Copy Code
    Dim sheet As XLSheet = c1XLBook1.Sheets(0)
    ' simple formula
    sheet(7, 0).Value = "Formula: 5!"
    sheet(7, 1).Value = 122
    sheet(7, 1).Formula = "1*2*3*4*5"
    c1XLBook1.CalculationMode = CalculationMode.Auto
    c1XLBook1.Save("c:\Save.xlsx")
    System.Diagnostics.Process.Start("c:\Save.xlsx")

    To write code in C#

    C#
    Copy Code
    XLSheet sheet = c1XLBook1.Sheets[0];
    // simple formula
    sheet[7, 0].Value = "Formula: 5!";
    sheet[7, 1].Value = 122;
    sheet[7, 1].Formula = "1*2*3*4*5";
    c1XLBook1.CalculationMode = CalculationMode.Auto;
    c1XLBook1.Save(@"c:\Save.xlsx");
    System.Diagnostics.Process.Start(@"c:\Save.xlsx");
  3. Run the project to open the Excel file. 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.