We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Incorrect rows sort order in Pivot tables with "Values" row (OP-8994)

Hi Support,
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.

Sheet_KO.JPG (104.8 KB)
Sheet_OK.JPG (105.9 KB)
OP-8994.zip (233.9 KB)


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.

The issue seems solved.


Good to know that your issue is sorted out by using the updated version. Feel free to contact us at any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

The issues you have found earlier (filed as CELLSNET-47024) have been fixed in Aspose.Cells for .NET v19.12. This message was posted using Bugs notification tool by Amjad_Sahi