Error when recalculating a pivot table

Aspose.Cells Product Family
1

Hi guys
I have a problem recalculating a pivot table.
There is always an error when I run the method “CalculateData”.
Can you check if this is a bug, because Excel doesn’t make any problems here.
I have attached a small example, when you run it, the error message appears.
I use the latest version of Aspose Cells (21.4.0).
PivotTableExample.zip (5.8 MB)

Thanks for your support.

2

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

This issue is logged as:
CELLSNETCORE-114 - Error when calculating a pivot table

3

@akquinet,

We are working over your issue. Once we figure it out, we will provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

Thanks for the support, I will test it then.

5

@akquinet,

We are pleased to inform you that your issue has been resolved. We will provide the fixed version in the next few days (3-5 days or so) after performing QA and incorporating other enhancements and fixes.

6

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

7

Good Job, it works fine.

8

@akquinet,

Good to know that your issue is sorted out by the suggested fix. In the event of further queries or issue, feel free to write us back.