[Regression] Pivot table styles not copied properly using the latest Aspose.Cells 22.6.0

Aspose.Cells Product Family
1

Hi,

When I tested today’s Aspose.Cells 22.6.0 release, I found the styles on pivot tables are no longer copied properly.

Code:

var workbook = new Workbook(@".\test.xlsx");
var newWorkbook = new Workbook();
newWorkbook.Copy(workbook);
newWorkbook.Save(@".\out22.6.0.xlsx");

Some coloured/bold styles are applied to the destination worksheet unexpectedly, making it different from the original workbook. This issue does not happen with older Aspose.Cells version 22.2.0.

I’ve attached the test files and a screenshot for your reference. The regression could be a blocker to use the latest Aspose release. Could you please help to take a look?

test.zip (27.2 KB)
image.png (40.1 KB)

Thanks,

2

@ServerSide527,

Thanks for the template file and screenshot.

Please notice, I am able to reproduce the issue as you mentioned by using your sample code with your template file. I found Pivot table styles are not copied properly using the latest version of Aspose.Cells for .NET v22.6. I have logged a ticket with an id “CELLSNET-51306” for your issue. We will look into it soon.

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

3

@ServerSide527,

This is to inform you that your issue has been resolved. The fix will be included in the next release (Aspose.Cells for .NET v22.7) which is scheduled in the second week of July 2022. You will also be notified when the next version is released.

4

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