Aspose.Cells.Workbook - Calling CalculateFormula throws System.NullReferenceException

Aspose.Cells Product Family
1

Hi, I’m working with Aspose.Cells for .Net version 23.11.0, and I receive the following error on calling CalculateFormula for a particular workbook:
System.NullReferenceException: ‘Object reference not set to an instance of an object.’
I’ve narrowed it down to a set of two worksheets within the workbook, sharing the simplified workbook for your reference. The code snippet used is as follows:

Workbook workbook = new Aspose.Cells.Workbook(<workbook path>);
                CalculationOptions calculationOptions = new CalculationOptions { IgnoreError = true };
                workbook.CalculateFormula(calculationOptions);

Interestingly, removing either of the worksheets causes the error to disappear. Please help to resolve this. Thanks!
TestAspose.zip (613.8 KB)

2

@AvneetK
By using sample file and code for testing on the latest version v24.4, we were able to reproduce the issue. Found that NullReferenceException occurs when calling CalculateFormula method.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55560

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@AvneetK,

We are pleased to inform you that your issue (filed as “CELLSNET-55560”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.5) that we plan to release in the first half of May 2024. You will be notified when the next version is released.