Dear sir/Madam,

      i am using aspose grid for excel upload and report. i have a file with 6 sheets . in the file third sheet has some formulas refered with sheet1. now i'm adding a row in sheet1 in sheet3 the formula has to automatically refereshed but in my application it doesn't happen. can you have any solutions for that please guide us . it is very urgent

awaiting your positive reply

Regards,

Unichem

Hi kartik,

You can use following line of code in order to calculate the formulas.

workbook.CalculateFormula();

Furthermore, please forward us the sample MS Excel file which contain sheets so that we can invetigate it in depth.

For more details on CalculateFormula please follow the links below:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/calculating-formulas.html

http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/data/calculate-formula.aspx

Thanks,