Issue refresh pivot table

Aspose.Cells Product Family
1
Hi

We have recently got a client issue with refreshing one of the pivot tables. I have attached the problem workbook.


Sample code for reporduce the issue:

string filePath = @"e:\ReportForASPOSE.xlsx";

Workbook sourceworkbook = new Workbook(filePath);


foreach (Aspose.Cells.Worksheet worksheet in sourceworkbook.Worksheets)
{

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

pivotTable.RefreshData();

pivotTable.CalculateData();

}//foreach

}//foreach


sourceworkbook.Save(filePath + ".out2.xlsm", SaveFormat.Xlsm);


Could you take a look to see 1) is the issue fixable? 2) what is the ETA if it is fixable, please?

We are currently using ASPOSE CELLS 7.1.5.0.


Thanks and regards

Bill

2

Hi,

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

We were able to observe this issue using your source code and sample file. When the code is executed, null reference exception is thrown. We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41891.

3

Hi,

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

It is to inform you, we have fixed this issue. We will provide you a fix in a next Aspose.Cells version which will be released in next week.

4

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.5.1.4 and let us know your feedback.

5

Hi Shakeel


I confirm that the issue is resolved with the new dll you provided. Much appreciate for the timely response and fix.


Thanks and regards

Bill
6

Hi,

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

It is good to know that your issue is resolved with the latest fix. If you encounter any other issue, please feel free to post on our forums, we will be glad to help you further.

7

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

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