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

Free Support Forum - aspose.com

Pivot table not keeping the format, but it works using 19.6 release (OP-9184)

Hi Support,
When generating Excel (PDF) document is not keeping pivot table format using the latest versions of Aspose.Cells, but it works using the 19.6 release.
See the documents attached: “Output_19.6.pdf” vs “Output_20.2.pdf”.
If I open the document in Excel and refresh the pivot data, the format will be right, but the customer creates the output in pdf.
I attach a simple program to replicate the problem.

Andrea Gasparin

OP-9184.zip (376.8 KB)
Output_19.6.pdf (37.7 KB)
Output_20.2.pdf (37.8 KB)

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47208 – Pivot table not keeping the format with latest version


This is to inform you that we have resolved your issue. After performing QA and merging other enhancements and fixes, we will soon provide you with a fixed version.


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

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.3.3 For .Net2_AuthenticodeSigned.Zip (5.3 MB)
Aspose.Cells20.3.3 For .Net4.0.Zip (5.3 MB)

Hi Amjad,
Thanks for the update, I will check the fix…

You are welcome.

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