Free Support Forum - aspose.com

Pivot Table Group Header Formatting

#1

Hi
When I copy over the cells from a pivot table over to another worksheet the pivot table group header row formatting is lost for all columns except the 1st column.
I have attached a sample project to recreate the issue.

AsposeTest.zip (302.1 KB)

#2

@aferriere2,

Thanks for the sample project with template file and details.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample code (“Program.cs”) with your template files. I confirmed the rows in the ‘PivotCopy’ sheet of output file have the below issue:

– The rows which were copied over from Worksheet ‘PivotOpenPositions’ To ‘PivotCopy’ does not have the correct format for the Header Rows from Pivot Table.
– Only cells in column A of the group header rows have the correct yellow background color. The cells in columns B to J of the group header rows does not have the yellow background color.

If we manually copy over cells A2 To J25 from ‘PivotOpenPositions’ To ‘PivotCopy’ all cells will have the proper formatting. I have logged a ticket with an id “CELLSNET-47010” for your issue. We will look into it soon.

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

#3

@aferriere2,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47010”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

#4

@aferriere2,

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

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.11.4 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.11.4 For .Net4.0.Zip (5.0 MB)

#5

Hi
Confirmed that the latest version fixes the issue.
Thanks

#6

@aferriere2,
Good to know that your issue is sorted out by the suggested hotfix. Feel free to contact us at any time if you need further help or have some other issue or queries, we will be happy to assist you soon.