ComponentOne Excel for .NET
In This Topic
    Setting the Calculation Mode for a Workbook
    In This Topic
    Show All
    Hide All

    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.