Does aspose.cells support updating formula values?

Aspose.Cells Product Family
1

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.

2

@vagelish

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