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
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
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.