Pivot table rows are not merged in PDF when the grand total is added (OP-95855)

Aspose.Cells Product Family
1

Hi Support,
In a pivot table that has the grand total for columns displayed, when the document is exported to PDF, the last rows of the pivot table are not merged.
I attached a simple program to replicate the problem and an image showing the difference between the pdf file created with Excel and the one with Aspose.Cells.

Br,
Andrea Gasparin

OP-95855.zip (44.1 KB)
PivotTable_Merged_Cells.png (66.2 KB)

2

@andreagasparin,

Thanks for the template XLSX file and screenshot.

We reproduced the issue after an initial test as you mentioned (via screenshot) by converting your template XLSX file to PDF file format. We found pivot table rows are not merged in PDF when the grand total is added in Excel to PDF conversion.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-53366

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Hello Amjad,
Thanks for the update.

Br,
Andrea Gasparin

4

@andreagasparin,

You are welcome. We will keep you posted with updates (once available) on it.

5

@andreagasparin,

We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.6) that we plan to release in the first half of June 2023. You will be notified when the next version is released.

6

The issues you have found earlier (filed as CELLSNET-53366) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi