Pivot table - Index was out of range

Aspose.Cells Product Family
,
1

Hello Guys,

i have a problem when I want to calculate the pivot table in the following example excel file.
I always get the following exception “Index was out of range. Must be non-negative and less than the size of the collection. (Parameter ‘index’)” when I call the method “CalculateData”.
I am using the current version 21.3.0 of Aspose.Cells and i attached a small example application so that you can understand it more easily.

PivotExample.zip (5.7 MB)

Thanks for your support.

2

@akquinet,
We have observed this issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-47935 - Exception raised while calling PivotTable.CalculateData()

3

@akquinet,

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

Thanks for your support.

5

@akquinet,
Please try the latest fix 21.3.3 .
Aspose.Cells21.3.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.3.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.3.3 For .NetStandard20.Zip (5.5 MB)

6

Thanks, work fine :slight_smile:

7

@akquinet,

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 happy to assist you soon.

8

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