"Index out or range" exception when refreshing Pivot Tables

Aspose.Cells Product Family
1

Hi!

Please find attached a source-code example that loads an XLSX file and refreshes the pivot tables on every worksheet; that fails with an index out of range exception. Tested with the newest (20.1) release as well with 19.11 and 19.12 - the exception keeps coming in all versions.

Kind Regards,
Bernd

Aspose.ErrorMsg.zip (5.2 MB)

2

@bernd.podhradsky,
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-47122 – "Index out of range" exception when refreshing Pivot Tables

3

@bernd.podhradsky,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47122”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@bernd.podhradsky,

Please try our latest version/fix: Aspose.Cells for .NET v20.1.4 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.1.4 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells20.1.4 For .Net4.0.Zip (5.0 MB)

5

Hi!

That seems to have fixed the issue, thx. Will this be included in 20.2? Or is it already safe to roll out 20.1.4 to customers?

Bernd

6

@bernd.podhradsky,
Thank you for the feedback. This fix is passed through all the tests which are performed for a regular release. You may please use it in your production environment as per your needs.

7

Moreover this fix will be included into v20.2.

8

The issues you have found earlier (filed as CELLSNET-47122) have been fixed in Aspose.Cells for .NET v20.2. This message was posted using Bugs notification tool by Amjad_Sahi