We are experiencing an issue with indirect formulas, not longer refreshing after file is saved using Aspose.
Take a look in the attached zip. (Indirect Fromula.zip (303.0 KB))
Inside you will see really simle app and the input file (Input.xlsb)
The app takes the input file recalculate the workbook and saves it in a different file.
Workbook workbook = new Workbook(“Input.xlsb”);
After that point the Output.xlsb no longer works.
To test this:
Change the value in B5. Column BC - should change the values.
image.png (44.9 KB)
This work properly in the Input.xlsb but note in Output.xlsb
Note: Output.xlsb works properly in Excel 2019, bit not in previous versions of Excel (ex. 2016)
Note 2: Going inside the cell and pressing enter refreshes the formula and starts working after that point.
Note 3: Pressing CTRL+ALT+F9 fixes the formulas and starts working after that point.