Bug 53255 - Row Grouping Code Which Works in XSSF Produces Invalid Excel in SXSSF
Summary: Row Grouping Code Which Works in XSSF Produces Invalid Excel in SXSSF
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.8-dev
Hardware: PC All
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2012-05-17 20:20 UTC by Greg Jungman
Modified: 2016-04-10 06:32 UTC (History)
1 user (show)


Note You need to log in before you can comment on or make changes to this bug.
Description Greg Jungman 2012-05-17 20:20:40 UTC

I have code that groups and collapses rows as shown below:

       sheet.groupRow(startGroup, endGroup);
       sheet.setRowGroupCollapsed(startGroup, true);

It works fine in XSSF, but if I change to SXSSF it produces an Excel workbook that Excel claims is corrupt.

Very large workbooks is when both of these feature are most useful.

Comment 1 Yegor Kozlov 2012-05-18 07:35:42 UTC
Are you using the latest release?
A similar problem was reported in Bugzilla 51673 and the fix is included in POI-3.8.

Comment 2 Ishmeet 2013-06-27 06:31:55 UTC
I am facing the same issue, also there is no code in the setRowGroupCollapsed method in SXSSF:

method from SXSSFSheet.class:

    public void setRowGroupCollapsed(int row, boolean collapse)
        //_sh.setRowGroupCollapsed(row, collapse);
        throw new RuntimeException("Not Implemented");

How does collapsing work otherwise in SXSSF Sheets?
Comment 3 Dominik Stadler 2016-04-10 06:32:15 UTC
In the latest version of POI, collapsing row groups is supported, only expanding the groups again is currently not implemented as this is usually not needed for streaming use-case that SXSSF supports. 

Please report fresh bugs for anything that is not working or if you think expanding should be supported and you have an idea about how it should be done.