Bug 57065 - Not able to open Pivot Table in mobile phones
Summary: Not able to open Pivot Table in mobile phones
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC other
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2014-10-08 02:46 UTC by Raj Basak
Modified: 2016-06-17 07:31 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Raj Basak 2014-10-08 02:46:56 UTC
We are using Apache POI to generate a Pivot Table for a given set of data. It works fine Mac and Windows version of MS Office, but not for the mobile phones.
A snippet of code is given below:

 String areaRefStr = "A1:H1000";
 AreaReference areaRef = new AreaReference(areaRefStr);
 //Find out where the Pivot Table needs to be placed 
 CellReference cellRef = new CellReference("A1");
 //Create Pivot Table 
 XSSFPivotTable pivotTable = sheet.createPivotTable(areaRef, cellRef, sheet2);
 pivotTable.addColumnLabel(DataConsolidateFunction.COUNT, 0); 

Following are the jars that we are using for generation:


Since we were not able to get much information from internet, want to know if this is an limitation from Apache POI end, or are we doing any mistakes during the Pivot generation.

Comment 1 Martin Andersson 2014-10-09 06:14:04 UTC
The pivot table support is very new so it hasn't been test in "the wild" very much. If you're willing to provide patches to fix the phone issues you're more than welcome.

My _guess_ is that the phone client relies on the precomputed cached values of the pivot table. The current POI implementation doesn't compute those.
Comment 2 David North 2015-10-29 10:51:19 UTC
Please can you confirm whether there is still an issue in the latest version (3.13) of POI? Please also clarify whether opening and saving the spreadsheet in desktop Excel makes it start working in the phone version. Lastly, please clarify exactly which phone app on what platform you are using to read the file.
Comment 3 Javen O'Neal 2016-06-17 07:31:40 UTC
Closing due to not enough information to recreate this bug.