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.
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:
PivotTable pivot = wb.getWorksheets().getSheet(0).getPivotTables().get(0);
I have logged your issue with an id: CELLSJAVA-26626. We will figure your issue out soon.