Hello,
After the post:
The issue still there, the calculated data for pivot table is not correct, and miss the style!
Refresh the pivot table of the attached excel file, can get the error.
Hi,
Thanks for your template file.
After an initial test using our latest version v2.5.3, I am able to find the issue as you have mentioned.
I can get the issue opening the generated file into MS Excel and the style is not correct also.
I am using the following sample code:
Sample code:
try{
wb.open(“e:\test2\refreshing\test.xls”);
PivotTable pivot = wb.getWorksheets().getSheet(0).getPivotTables().get(0);
pivot.refreshData();
pivot.calculateData();
wb.save(“e:\test2\refreshing\out_test2.xls”);
}catch(Exception e){
e.printStackTrace();
}
I have logged your issue with an id: CELLSJAVA-26626. We will figure your issue out soon.
thank you.
Hi,
Hi,
The issues you have found earlier (filed as 26626;26626) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.