Calculated Values Not Accepted by Pivot Table's RefreshData()

Aspose.Cells Product Family
1

Hi


We are having a problem with refreshing pivot tables which contains calculated values when converting to PDF.
When we try to refresh a pivot table with one, the pivot table in the generated PDF file contains an the wrong data.

I have attached a mini project that demonstrates this problem.
I have also attached an excel file “testFile.xlsx” which you can open using the mini project.

NOTE: We are currently using version 7.4.2.4 of Aspose.Cells

Thank you.
2

Hi,

Thanks for your posting and using Aspose.Cells.

We
have found this issue. The data in generated pdf at page number 1 is corrupt and needs to be fixed.

We have logged this issue in our
database. We will look into this issue and resolve it. 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-41581.

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.5 and let us know your feedback.We have also attach output pdf for your reference.

Please add the following line of code after sort:


foreach (Worksheet sheet in book.Worksheets)

{

foreach (Aspose.Cells.Tables.ListObject lo in sheet.ListObjects)

{

lo.AutoFilter.Sorter.Sort();

lo.AutoFilter.Refresh();

}

}


book.CalculateFormula();


4

Hi,


Just confirming that our pivot tables are now displaying the correct data.

Thank you
5

Hi,


Good to know that your issue is resolved. We have already closed your ticket now.

Feel free to contact us any time if you have some other query or have some other issue, we will be happy to assist you soon.

Thank you.
6

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

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