ArrayFormula to be updated once opened.

[Rieky]

Hi,

I have created an Excel file containing ArrayFormulas.
The file was created successfully and what is intended is that these formulas to be calculated and updated when the file is opened.

Is there a way to achieve this?

Thanks.

[Rieky]

PS: I have used

workbook.CalculationOptions.CalculationMode = ExcelCalculationMode.Automatic;

It still doesnt work

[Manoj Kumar G M]

Hi,

Thank you for choosing Syncfusion products.

Essential XlsIO includes support for enabling the calculations of Essential Calculate supported formulas that are added at runtime to the worksheet and the computed value will be set to the “CalculatedValue” property associated to the “IRange” object. The following code snippet illustrates how to enable the sheet formula calculations.

[C#]

IWorksheet sheet = workbook.Worksheets[0];

//Formula calculation is enabled for the sheet.

sheet.EnableSheetCalculations();

Please go through our documentation in the link below.

http://help.syncfusion.com/UG/Reporting/XlsIO/Windows%20Forms/default.htm#!Documents/addingcalculationenginetoanapplication.htm

Please let us know if you require any further clarifications.

Regards,
Manojkumar.