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

Free Support Forum - aspose.com

Pivot table's header texts from the second column onwards are wrong in PDF form


We our pivot table seems to be resetting back to the source table’s column header text. e.g. if the source table contains a column called “Address” but in the pivot table the column is named “TEST”. In this case the pivot table’s column header text reverts back to “Address” when the pivot table is updated with the “CalculateData()” method call.

I have attached a small project to demonstrate the problem. I have also attached an input file “input file pivot header difference.xlsx” for you to use.

The images attached shows the difference between the print preview of the generated xlsx file, and the pdf file’s pivot tables.

Additional Details:
  • Currently using v7.5.0.1 of Aspose.Cells
  • Attached input file was previously generated with the use of Aspose.Cells.


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

We were able to notice this issue using your sample application and source 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-41765.

We have attached the output files for a reference.


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.

Thank you.