Pivot table formatting problem

Aspose.Cells Product Family
1

I have problems with pivot table formatting, The code is next

Workbook book = new Workbook("template.xlsx");

foreach (Worksheet sheet in book.Worksheets)
{
if (sheet.PivotTables.Count > 0)
{
PivotTable table = sheet.PivotTables[0];
table.RefreshData();
table.CalculateData();
}
}

book.Save("saved.xlsx");

Source template.xlsx and resulting saved.xlsx are in attachment.

Column widths changed, cells shifted, result is ugly.

I use 7.4.1.2 Aspose.Cells.

BTW, with 7.2.2 Aspose.Cells all Ok.

2

Hi,

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

We were able to replicate this issue using your sample files and code. We have logged this issue in our database. We will look into this issue and fix it. Once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41509.

3

Hi,

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

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.2.1 and let us know your feedback.

4

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

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