Bug 61528

Summary: [PATCH] Pivot Table enhancements
Product: POI Reporter: Roland <bug.poi>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: enhancement Keywords: PatchAvailable
Priority: P2    
Version: 3.17-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: zip with created excel, new XSSFPivotTable.java und example CreatePivotTable2.java

Description Roland 2017-09-16 23:09:57 UTC
Created attachment 35331 [details]
zip with created excel, new XSSFPivotTable.java und example CreatePivotTable2.java

Hi,

I need some enhancements on pivot table just like set the format of the value and set a data column for columns (like rows) and format the value.

I have checked out the current trunc from 17.09.2017 and added my enhancements.
I have also fixed the bug 58294 (may be the same problem in bug 60094) - changes in function addReportFilter.

The attachment contains:
+ ooxml-pivottable.xlsx - this can I create with the new XSSFPivotTable
+ XSSFPivotTable.java (src\ooxml\java\org\apache\poi\xssf\usermodel)
+ CreatePivotTable2.java (src\examples\src\org\apache\poi\xssf\usermodel\examples)

Please verify it and check in the new files.
Comment 1 PJ Fanning 2017-09-17 01:40:38 UTC
Hi Roland,
Thanks for the submission. If you have time, would it be possible to create a pull request at https://github.com/apache/poi? I, for one, find it easier to review github changes.
Comment 2 Roland 2017-09-18 20:35:44 UTC
Hi,
here is the pull request: https://github.com/apache/poi/pull/71
Comment 3 PJ Fanning 2017-09-20 08:25:24 UTC
Pull Request merged