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

Free Support Forum - aspose.com

Pivot table has an extra column


We are experiencing an issue with pivot tables; When a compact pivot table is updated using “CalculateData()” the resultant file seems to have the data in the wrong place. Instead of having a column one column to the left when the pivot table has one column pair in compact mode, the resultant file’s pivot table’s data is in tabular mode (only the pivot table itself is in compact mode).

I have attached a small project to demonstrate this issue. I have also attached an input file “input file compact pivot table.xlsx” for you to use.

The attached screenshot shows the difference in the files.


Thanks for your posting and using Aspose.Cells for .NET.

We were able to observe this issue using your sample application and source file. The pivot table has extra column in the output file. We have logged this issue in our database. We will look into it and resolve this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41764.


We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.5.0.2 and let us know your feedback.