Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

The CalculateFormulas method calculates any Calculation Engine Supported Formulas in the workbook. Any formulas in the workbook that are not supported by the Calculation Engine will be set as 0.

Signature
0csharp
 wb. public void CalculateFormulas();
Signature
0vb
 wb.CalculateFormulas()
 Public Sub CalculateFormulas()

 

 

Example
Code Block
titleC#
languagec#
//Create an ExcelApplication object
ExcelApplication xla = new ExcelApplication();

//Open a workbook containing formulas
Workbook wb = xla.Open("FormulasWorkbook.xlsx); 
 
//Call CalculateFormulas
wb.CalculateFormulas();
Code Block
titleVB
languagevb
'Create an ExcelApplication object
Dim xla As New ExcelApplication
 
'Open a workbook containing formulas
Dim wb As Workbook = xla.Open("formulasWorkbook.xlsx")
 
'Call Calculateformulas
wb.CalculateFormulas()