We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Does aspose.cells support updating formula values?

I have a complex xlsx file with several sheets and formulas.

I’d like to be able to edit its content, then recompute all formula cells, and then read the new values, from a Java program in Linux.

Do you support this? I am especially interested in the dynamically updating the values, which is the only feature not supported by Apache POI.


Thanks for your query.

Aspose.Cells supports calculating formulas of a worksheet anytime as per your requirements. You can use CalculateFormula() method for this purpose. Also refer to below document for more information:

Ways to Calculate Formulas