Hi Matthew,
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();
string
computedValue = sheet.Range["C1"].CalculatedValue;
Please go through our documentation in the link
below.
http://help.syncfusion.com/UG/Reporting/XlsIO/Windows%20Forms/default.htm#!Documents/addingcalculationenginetoanapplication.htm
We have attached the sample in the below link.
Please make use of this sample and let us know if this helps you.
SampleLink:
http://www.syncfusion.com/downloads/Support/DirectTrac/93766/NamedRanges-1274090944.zip
Please let us know if you require any further
clarifications.
Regards,
Manojkumar.