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.
@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
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.
Thanks for the support, I will test it then.
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.
@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)
Good Job, it works fine.
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.