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

Free Support Forum - aspose.com

PivotTables loop and set order


Thanks for providing us your expected file containing the PivotTable with your desired sort order.

Well, as you need to sort data field with respect to row field in PivotTable (see the screenshot here: http://prntscr.com/b6a9we), but I am afraid, this feature is not supported. We already logged a ticket "CELLSNET-43257" for this unsupported feature. I have logged a ticket "CELLSNET-44451" for the task. We will check if we can provide you some workaround using Aspose.Cells APIs to accomplish your task. Once we devise a code snippet to achieve his desired results, we will share it with you here.

Keep in touch.

Thank you.


One idea… is possible to copy and paste the entirre sheet into another new sheet as VALUES (not pivot table). Then i can sort normally the columns as i want… or not? Can you paste the code for do it?


I am afraid, there is no update on your issue logged earlier as “CELLSNET-44451”. I have asked the concerned developer from product team to update on it. Once we have an update on it, we will let you know here.

Regarding your recent query, well, you may try to create a range based your worksheet data/area and then paste values/data into other worksheet (after creating the destination range) using Range.CopyValue and Range.CopyData methods, see the documents for your reference:

Note: please don’t forget to call PivotTable.RefreshData() and PivotTable.CalculateData() methods before creating and copy/pasting ranges b/w worksheets.

Thank you.


Thanks for using Aspose.Cells.

We are afraid, we can’t support sorting the PivotField via DataField. We will support it later, but we have no plan for it now.


Too complicated...
We'll wait for the version with this feature


Please try our latest version/fix: Aspose.Cells for .NET v19.11.8 (attached).

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.11.8 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.11.8 For .Net4.0.Zip (5.0 MB)

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