Hi Khai,
Thank you for your interest in Essential XlsIO.
You should use Essential Calculate along with Essential XlsIO to calculate before saving the file.
[C#]
//Inserting sample text
sheet.Range["A1"].Number = 10.99;
sheet.Range["B1"].Number = 10;
sheet.Range["C1"].Formula = "A1+B1";
sheet.Range["D1"].Formula = "AVERAGE(A1:B1)";
//Refresh the calculation engine. The second parameter is true since this is the
//first time we are calling this.RefreshCalcEngine
this.RefreshCalcEngine(workbook,true);
Please refer the sample in the below link which illustrates the above.
http://websamples.syncfusion.com/samples/XlsIO.Windows/66997/main.htmPlease try running the above sample and let me know if this helps.
Thanks,
Melba