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

Free Support Forum - aspose.com

Preset formulas on cells assigned using Cells don't work anymore

We use a template Excel file, that we load, populate and save. If in the original template there are formulas that involve one of the cells we fill using Cells, these formulas stop working even when the Excel file is opened in Excel. We need to click on the cells filled programmatically, hit enter and then the formulas in the other cells become active and are calculated. We’re using Aspose Cells for .net 21.9.0.0 and a link to an Excel file thus obtained is available for download here: https://bit.ly/3JiydoN

@giorgio.malagutti

Please call Workbook.CalculateFormula() before saving the file, it should fix your issue.

Let us know if you still find any issue.

Amjad,
Thank you for the prompt answer, it worked indeed.
Giorgio

@giorgio.malagutti,

Good to know that your issue is sorted out by the suggested line of code. Feel free to write us back if you have further queries or comments.