Existing formula calculation

Question

Hi,My requirement is something like, I have a template (with no data) with some formulas in it. My application tries to update the excelsheet with data using Syncfusion Xlsio, and save the file. But when the file is opened I see the data but formulas are not calculated.I want the existing formulas should get calculated as the data is populated.Thanks,Abha

Zakeer Ahmed S · Answer

Hi Abha,Thank you for your interest in Syncfusion products.I am able to reproduce the problem of ‘formulas are not calculated after adding data’. You can work around this by calculating the Excel sheet programmatically using integrated Calculate Engine. I have placed the sample in the link below. sample-64069450.zipAlso, you can check the documentation in the following link for working with Calculate Engine:http://help.syncfusion.com/ug_83/Reporting/XlsIO/ASP.NET/Documents/calculationengine.htmPlease let us know if you have any questions.regardszakeer Ahamed.s