Free Support Forum - aspose.com

Question About Calculating a Cell- a Row- or a Sheet

Aspose.Cells Product Family
#1

Hello <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />Nanjing –<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I do not know how to join your forum, so I will ask my question directly to you.

If I am using a pre-existing Excel spreadsheet that contains simple mathematical formulas (A1 * B1), can I get a Cell, a Row, or an entire Sheet to recalculate without having to save and manually re-open the spreadsheet?

Thank you for your answer.

Gordon McNeil

Cambridge, Massachusetts

U.S.A.

This message was posted using Email2Forum by nausherwan.aslam.
#2

Hi Gordon,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

If you want to calculate the formula results at runtime, you may use the Workbook.CalculateFormula() API after setting the formulas. Please see the following documentation link for overloaded methods available for CalculateFormula:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/aspose.cells.workbook.calculateformula_overloads.html

Thank You & Best Regards,