https://bz.apache.org/bugzilla/show_bug.cgi?id=57623
Bug ID: 57623
Summary: Nested column groupings not working
Product: POI
Version: 3.11-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 32509
--> https://bz.apache.org/bugzilla/attachment.cgi?id=32509&action=edit
Example code creating nested column groups
Excel supports nested column groups, but this feature is broken in POI (both in
HSSF and XSSF implementations).
Assume that one wants to create two levels of column groupings, e.g. a group of
columns 0 to 6 and two "sub-groups" of columns 0,2 and 4,6 as depicted below:
| A | B | C | D | E | F | G |
|++++++++++GROUP 1++++++++++|
|+++GROUP 2+++|+++GROUP 3+++|
The problem is that although the groups can be created, access to the groups is
lost after creation (e.g. to set their collapsed/expanded attribute), as the
POI API only provides methods to access column groups by columns they contain
and no means to access groups on a given level; for fully overlapping groups
thus access is lost, see function setColumnGroupCollapsed,
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int,%20boolean)
Example code for XSSF is attached. The xlsx should contain the nested column
groups as described above, with all of them being collapsed initially. This is
not the case though, as access to the groups 2 and 3 is lost.
Thanks for investigating this!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
