Aspose team,
I’m running into another XLSB problem. Take a look at the attached program. It generates two workbooks, one XLSB and one XLSX.
Each workbook contains a formula in cell A3, which uses INDIRECT to calculate A1 * A2:
= INDIRECT(“A1”) * INDIRECT(“A2”)
Open the XLSX generated by the attached program and change A1 or A2, and A3 is automatically re-calculated.
In the XLSB version, if you change A1 or A2, A3 is not automatically recalculated. You have to change the formula and hit enter for it to recalc.
Under different circumstances I would simply remove the INDIRECT function, but I need to use it in order to eliminate #REF! formula issues due to dragging/dropping cells.
I am using Aspose.Cells .NET v6.
Thanks!
Jim