A Small Problem with Sorting in Pivot Tables

Aspose.Cells Product Family
1

Hi guys,
I have the problem with the checkbox “AutoSort” it is always active.
I deactivate this function and save the workbook with Aspose.Cells 22.11.0 and the checkbox is active again.
Can you take a look here to see what the reason is?
I attached the pictures how to get to the dialog and a test application.
In the file “Input.xlsx” the checkbox was deactivate, after saving the workbook, the checkbox is activated again in the “Output.xlsx”.

Image1.png (15.5 KB)
Image2.png (7.4 KB)
Image3.png (7.9 KB)
PivotSortCheckbox.zip (288.8 KB)

Thanks for your support.

2

@akquinet,

Thanks for the sample files and screenshots.

Please notice, I am able to reproduce the issue as you mentioned via screenshots. I found AutoSort option is enabled for the pivot field when re-saving your XLSX file via Aspose.Cells for .NET APIs. I have logged a ticket with an id “CELLSNET-52298” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@akquinet,

This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells 22.12) which is scheduled in the first half of December, 2022. You will also be notified when the next version is released.

4

Thank you very much, I will test it when the release comes out. :slight_smile:

5

@akquinet,

You are welcome.

6

The issues you have found earlier (filed as CELLSNET-52298) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi