Pivot table seems to be using the cell Bold setting of the worksheet instead of the pivot table when converting to PDF

Aspose.Cells Product Family
1

Hi,

We have come across an issue with the formatting of some of our pivot tables when the xlsx file is converted to PDF. For some reason although in XLSX the 4th column is not bold, when the XLSX file is converted into a PDF file some of the items in the 4th column is set to bold (note not all items are set to bold). What’s odd is that this does not happen to all pivot tables, and it definitely did not happen when using Aspose.Cells 7.5.2.0. We found this issue in 7.5.2.1 and are still able to produce it in 7.5.2.2.

I have attached a small project to demonstrate the issue. I have also attached an input file for you to use. The input file contains a pivot table that has the “B” worksheet column set to be bold before fields we’re added to the pivot table.

In Excel the pivot table values are not bold, but in the output file “generated file.pdf” the pivot columns that are in the “B” worksheet columns are set as bold (as shown in the screenshot).

2

Hi,


Thanks for providing us sample project and sharing the template file.

After an initial test, I observed the issue as you mentioned by using your sample project with your template file. When rendering to PDF file after refreshing the Pivot table the field’s items in the Title column is set to bold. I have logged a ticket with an id “CELLSNET-41978” for your issue. We will look into your issue soon.

Once we have any update on it, we will let you know here.

Thank you.
3

Hi,

Sorry to be a pain, but could you give me an information about progress in this issue please?
I need to give my manager daily update on the status of this issue. We’re aiming to be have a releasable build of our project next week, and we need to know if this is still a possibility.

Thank you

4

Hi,

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

We have checked your issue status from our database. We are pleased to inform you that your issue is fixed. Please wait for major release which will be published soon.

5

Thank you for this information, my manager will be looking forward to this.

6

The issues you have found earlier (filed as CELLSNET-41978) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.