Hi,
Using Aspose Cells for Java, version 20.4.
Calculating the linked workbook results in the following exception:
Exception in thread "main" com.aspose.cells.CellsException: java.lang.NullPointerException: null("Based on cell "Companies Broker!H7)
at com.aspose.cells.zaec.a(Unknown Source)
at com.aspose.cells.zaec.a(Unknown Source)
at com.aspose.cells.zaed.a(Unknown Source)
at com.aspose.cells.zaed.b(Unknown Source)
at com.aspose.cells.zaec.b(Unknown Source)
at com.aspose.cells.Workbook.calculateFormula(Unknown Source)
at com.aspose.cells.Workbook.calculateFormula(Unknown Source)
at com.aspose.cells.Workbook.calculateFormula(Unknown Source)
at my.main.method.Test.main(Test.java:15)
Sample code:
Workbook workbook = new Workbook("sample.xlsx");
workbook.calculateFormula();
Please note that the calculation takes about 2 hours before failing, while the calculation completes in Excel in around 15 minutes.
Link to reproduction workbook: https://1drv.ms/u/s!AtPL-qSRXJ4ajbg9nrUTLBtnQAaOlg?e=LpAEp2
Kind regards,
Taras