Issue with refreshing pivot tables

Aspose.Cells Product Family
1
Hi

We have recently got a client issue with refreshing one of the pivot tables in 2 files after upgrading to version 7.5.3. I have attached the problem workbooks.


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?



Thanks and regards

Bill
2

Hi,

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

We were able to replicate the exceptions using your source files with the given sample code. When the code is run, System.InvalidCastException occurs. We have logged this issue in our database. 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-42003.

3

Thanks Shakeel! The System.InvalidCastException is the error that we got as well.



Cheers

Bill
4

Hi,

Thanks for your confirmation.

Once, we will have some fix or update for you, we will let you know asap.

5

Hi Shakeel


Could you provide us an ETA for this issue, please? We are planning to do a release at the end of this month and this issue is critical to us to decide which ASPOSE version to use in this release.


Regards

Bill
6

Hi,

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

We have checked your issue status from database and found your issue is fixed. We will release a fix in this week. Please spare us some time. Once, we will have some update for you, we will let you know asap.

7

Sure. Thanks Shakeel! This is great news.



Regards

Bill
8

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

9

Hi Shakeel


This issue is confirmed resolved. Thanks very much for your help!


Regards

Bill
10

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that latest version has resolved this issue. If you encounter any other issue, please feel free to post, we will be glad to help you further.

11

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

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