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

Area.CalculateFormulas()

Introduced in buil= d 9.1

Description

Calculates any=20 Calculation Engine Supported Formulas in the area. Any formulas in the area that are not supported by the Calcu= lation 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); 

 
// Create an area
Area a=3D wb[0].CreateArea("=3DA1:C4");
 
//Call CalculateFormulas
a.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")
 

'Create an area
Dim a as Area=3D wb[0].CreateArea("=3DA1:C4")
 
'Call Calculateformulas
wb.CalculateFormulas()
=20
------=_Part_8880_487002148.1711666439643--