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)

@andreagasparin,

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.

@andreagasparin,

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.

@andreagasparin,
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.