java.lang.NullPointerException: null("Based on cell "Facultatives!BA7)

Aspose.Cells Product Family
1

Hi,

Using Aspose Cells for Java, version 20.6.

Sample code:

System.out.println("CellsHelper.getVersion() = " + CellsHelper.getVersion());
Workbook workbook = new Workbook("sample_fails_quick1.xlsx");
workbook.calculateFormula();

Output:

CellsHelper.getVersion() = 20.6.0
Exception in thread "main" com.aspose.cells.CellsException: java.lang.NullPointerException: null("Based on cell "Facultatives!BA7)
	at com.aspose.cells.zaeb.a(Unknown Source)
	at com.aspose.cells.zaeb.a(Unknown Source)
	at com.aspose.cells.zaec.a(Unknown Source)
	at com.aspose.cells.zaec.b(Unknown Source)
	at com.aspose.cells.zaeb.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)
          (...)

sample_fails_quick1.zip (526.9 KB)

Kind regards,
Taras

2

@TarasTielkes,

Please try our latest version/fix: Aspose.Cells for Java v20.6.4：
aspose-cells-20.6.4-java.zip (7.1 MB)

I have tested your sample code with your template file using Aspose.Cells for Java v20.6.4 and it works fine and I do not get any exception.

Let us know your feedback.

3

Hi @Amjad_Sahi,

You are right, the problem is not reproducible with Aspose Cells for Java, version 20.6.4.

We did however, reproduce a problem that seems similar, and I have reported it in a new forum post here: Calculation fails with NPE

Kind regards,
Taras

4

@TarasTielkes,

Good to know Aspose Cells for Java, version 20.6.4 sorts our your issue (you posted in the first post in this thread).

Regarding your other issue, please follow up your other thread for updates or fix.