Bug 61528 - [PATCH] Pivot Table enhancements
Summary: [PATCH] Pivot Table enhancements
Status: RESOLVED FIXED
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
URL:
Keywords: PatchAvailable
Depends on:
Blocks:
 
Reported: 2017-09-16 23:09 UTC by Roland
Modified: 2017-09-20 08:25 UTC (History)
0 users


Attachments
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 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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

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