By refreshing pivot table data via Chart.RefreshPivotData() removes axis number format in .NET

Aspose.Cells Product Family
1

Hello,
I have an excel template and in the template I have a pivot table&chart. After I fill the template with data I’m using Worksheet.RefreshPivotTables() method to refresh the pivot tables with new data, and I’m also using Aspose.Cells.Charts.Chart.RefreshPivotData() method so the charts are also refreshed with new pivot tables. but using Aspose.Cells.Charts.Chart.RefreshPivotData() causes pivot charts number format on value axis to be changed with another format. Please see attached sample project to reproduce my issue. after running the project there is going to be a png of pivot chart in the debug folder. you can realize that the number format is different on that png compared to the actual chart on the excel file(excel file is also saved in debug folder). 2018_11_27_14_04_52_Chart_3.png_Windows_Photo_Viewer.png (15.7 KB) Can you offer me a solution to overcome this issue?
Thanks.
ConsoleApp11-2.zip (28.3 KB)

2

@ahmeturun,

Thanks for your query.

After an initial test, we were able to reproduce the issue by converting pivot chart to png and observed the change in number format. We will investigate your issue in details and try to figure it out soon.

3

@ahmeturun,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46469 - Aspose.Cells.Charts.Chart.RefreshPivotData() removes axis number format
4

@ahmeturun,
Please try the latest fix 21.2.7.
Aspose.Cells21.2.7 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.2.7 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.2.7 For .NetStandard20.Zip (5.5 MB)

5

The issues you have found earlier (filed as CELLSNET-46469) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao