Issue with refreshing pivot tables in version 7.1.2.0

Aspose.Cells Product Family
1

Hi

We recently migrated to ASPOSE 7.1.2.0 from 7.1.0.5 to fix one of our issue, but it seemed that refresh pivot table corrupt the excel files. We have attached the file for you to test and also the error message from Excel.

The core code we use to reproduce this bug is:

foreach (Aspose.Cells.Worksheet worksheet in workBook.Worksheets)

{foreach (Aspose.Cells.Pivot.PivotTable pivotTable in worksheet.PivotTables)

{

pivotTable.RefreshData();

pivotTable.CalculateData();}

}

We have a deployment scheduled this weekend and this is an critical item that could stop the deployment. Could you take a look and see if it is possible to fix it ASAP? Much appreciated for you support effort!

Regards

Bill

2

Hi,

It appears this issue has been fixed in version 7.1.2.6. We are all good now:)

Regards

Bill

3

Hi,

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

It’s good to know that latest version has already fixed the problem.

If you face any other problem, please feel free to post, we will help you asap.