Workbook CalculateFormula InvalidCastException

Aspose.Cells Product Family
1

Hi there,

We’re seeing an InvalidCastException thrown when calling CalculateFormula on the attached sheet.

The following code:

Workbook w = new Workbook(“Exception.xlsx”);
w.CalculateFormula();

Causes the following exception:

InvalidCastException: Unable to cast object of type ‘System.Double[]’ to type ‘ []’.(Based on cell Calcs!L853)

It seems the problem was introduced in v19.10.0 - the last version the calculation works without an exception is v19.9.0.

Could someone investigate this for us?

Thanks

Exception.zip (761.3 KB)

2

@WaterOutlook,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47700 - CalculateFormula throws InvalidCastException
3

@WaterOutlook,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@WaterOutlook,

Please try our latest version/fix: Aspose.Cells for .NET v20.10.8 (attached)
Aspose.Cells20.10.8 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.10.8 For .Net4.0.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

Thanks for the prompt update, I can confirm this fixes this problem.

6

@WaterOutlook,

Good to know that your issue is resolved by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

7

The issues you have found earlier (filed as CELLSNET-47700) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao