Message-ID: <927624279.8453.1711647157214.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8452_1290564197.1711647157214" ------=_Part_8452_1290564197.1711647157214 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Workbook.CalculateFormulas

Workbook.CalculateFormulas

Description

The CalculateFormulas method calculates any=20 Calculation Engine Supported Formulas in the workbook. Any formulas in the workbook that are not supported by t= he Calculation Engine will be set as 0.=20
C#
=20
 public void CalculateFormulas()
=20
=20
vb.net
=20
 Public Sub CalculateFormulas()
=20

 

 

=20

Examples

=20
C#
=20
//Create an ExcelApplication object
ExcelApplication xla =3D new ExcelApplication();

//Open a workbook containing formulas
Workbook wb =3D xla.Open("FormulasWorkbook.xlsx); 
 
//Call CalculateFormulas
wb.CalculateFormulas();
=20
VB
=20
'Create an ExcelApplication object
Dim xla As New ExcelApplication
 
'Open a workbook containing formulas
Dim wb As Workbook =3D xla.Open("formulasWorkbook.xlsx")
 
'Call Calculateformulas
wb.CalculateFormulas()
=20

 

 

 

------=_Part_8452_1290564197.1711647157214--