Free Support Forum - aspose.com

Sorting pivot column in Aspose.Cells

Hi Aspose,

In the pivot table I have created, I’m using a column containing two values. This way I split up my total.

The result looks something like this (extract showing the column area)

Total Investment
Project PreProject
140
120

In Excel the columns are in reverse order, which is the way I want it. I’ve tried setting different column sorting, but none of the settings has any effect.

How do I change the column order?

B R
Anders

Hi,

Well, Aspose.Cells for .NET creates the pivot table similar to what MS Excel does. Could you create a sample template file containing the pivot table manually in MS Excel to show how your pivot table should be.
Also provide your sample code with template file using Aspose.Cells for .NET to show how the component is rendering the pivot table report.
We will check it soon. By the way, did you try the latest version 4.8.1.x: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry207989.aspx

if not, kindly try it first.

Thank you.