We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

ArrayFormula to be updated once opened.

Thread ID:

Created:

Updated:

Platform:

Replies:

105507 Nov 1,2012 04:01 AM UTC Nov 5,2012 08:51 AM UTC WinForms 2
loading
Tags: XlsIO
Rieky
Asked On November 1, 2012 04:01 AM UTC

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
Replied On November 1, 2012 04:48 AM UTC

PS: I have used

workbook.CalculationOptions.CalculationMode = ExcelCalculationMode.Automatic;

It still doesnt work

Manoj Kumar G M [Syncfusion]
Replied On November 5, 2012 08:51 AM UTC

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.


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;