We have found an issue where values that are part of a pivot table is retained after the “CalculateRange()” method is called; Even though the values are no longer part of the pivot table they are still in the worksheet.
I have attached a small project to demonstrate the issue. I have also attached an input file “input file with data.xlsx” for you to use. The input file contains a “ListObject” containing data.
The project code deletes all values from the ListObject except for the first data row, before refreshing the pivot table.
The output file “generated file.xlsx” still have values under the pivot table (the values were part of the original pivot table before the refresh)
Thanks for your posting and using Aspose.Cells for .NET.
We were able to observe this issue. The pivot table in the output file still have old values that are not part of the pivot table. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is fixed or we have some other update for you, we will let you know asap.
We have attached the output file for a reference.
This issue has been logged as CELLSNET-42128.
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)
Your issue should be fixed in it.
Let us know your feedback.