When is copied a sheet that contains a pivot table with the “Values” row the rows order in the pivot table is wrong.
See the images attached.
I will attach a simple program to replicate the issue.
Thanks for the sample project, template file and screenshots.
After an initial test, I am able to observe the issue as per your screenshots using your sample project with your template file. I found the copied sheet contains the pivot table with the “Values” rows order wrong in the output file. I have logged a ticket with an id “CELLSNET-47024” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
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.
Please try our latest version/fix: Aspose.Cells for .NET v19.11.7:
Aspose.Cells19.11.7 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.11.7 For .Net4.0.Zip (5.0 MB)
Aspose.Cells19.11.7 For .NetStandard20.Zip (4.1 MB)
Your issue should be fixed in it.
Let us know your feedback.