Bug 61528 - [PATCH] Pivot Table enhancements
Summary: [PATCH] Pivot Table enhancements
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.17-dev
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Keywords: PatchAvailable
Depends on:
Reported: 2017-09-16 23:09 UTC by Roland
Modified: 2017-09-20 08:25 UTC (History)
0 users

zip with created excel, new XSSFPivotTable.java und example CreatePivotTable2.java (11.55 KB, application/x-zip-compressed)
2017-09-16 23:09 UTC, Roland

Note You need to log in before you can comment on or make changes to this bug.
Description Roland 2017-09-16 23:09:57 UTC
Created attachment 35331 [details]
zip with created excel, new XSSFPivotTable.java und example CreatePivotTable2.java


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
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