You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/02/23 13:57:51 UTC
[Bug 57623] New: Nested column groupings not working
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: dev@poi.apache.org
Reporter: effenberger.felix@gmail.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57623] Nested column groupings not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57623
Eugene Kortov <ko...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC|kortovea@gmail.com |
--
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 57623] Nested column groupings not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57623
Eugene Kortov <ko...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kortovea@gmail.com
--
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 57623] Nested column groupings not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57623
effenberger.felix@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |effenberger.felix@gmail.com
--
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