|103627||May 18,2012 06:43 AM UTC||May 18,2012 11:36 AM UTC||Silverlight||1|
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.
IWorksheet sheet = workbook.Worksheets;
//Formula calculation is enabled for the sheet.
string computedValue = sheet.Range["C1"].CalculatedValue;
Please go through our documentation in the link below.
We have attached the sample in the below link. Please make use of this sample and let us know if this helps you.
Please let us know if you require any further clarifications.
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.