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.