Hi,
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.