Bug 66216 - XSSFPivotTable.getPivotCacheDefinition() does not work properly when XSSFPivotTable was read from an existing *.xlsx file
Summary: XSSFPivotTable.getPivotCacheDefinition() does not work properly when XSSFPivo...
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 5.2.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-08-15 16:36 UTC by Axel Richter
Modified: 2022-08-18 23:17 UTC (History)
0 users



Attachments
Sample Java code and sample *.xlsx file (15.12 KB, application/x-zip-compressed)
2022-08-15 16:36 UTC, Axel Richter
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Axel Richter 2022-08-15 16:36:31 UTC
Created attachment 38368 [details]
Sample Java code and sample *.xlsx file

Take the code ReadExcelPivotTableSource.java and the ExcelPivotTableSample.xlxs from my attachment. Run the code.

You will see that pivotTable.getPivotCacheDefinition() always returns `null` although the POIXMLDocumentPart is present.
Comment 1 PJ Fanning 2022-08-15 18:54:41 UTC
Definitely a bug - pivotTable.getCTPivotTableDefinition() does work

I'll look into the issue with pivotTable.getPivotCacheDefinition()
Comment 2 PJ Fanning 2022-08-15 19:21:05 UTC
I added a fix using r1903442