[Bug 57065] New: Not able to open Pivot Table in mobile phones

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=57065

            Bug ID: 57065
           Summary: Not able to open Pivot Table in mobile phones
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: other
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: raj.basak@gmail.com

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.addRowLabel(3);
 pivotTable.addColumnLabel(DataConsolidateFunction.COUNT, 0); 

Following are the jars that we are using for generation:

poi-3.11-beta2-20140822.jar
poi-ooxml-3.11-beta2-20140822.jar
poi-ooxml-schemas-3.11-beta2-20140822.jar

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.

Regards
Raj

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57065] Not able to open Pivot Table in mobile phones

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=57065

--- Comment #1 from Martin Andersson <ma...@purplescout.se> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org