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
Status: RESOLVED WORKSFORME
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-17 20:20 UTC by Greg Jungman
Modified: 2016-04-10 06:32 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

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 
Hello,

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.

Thanks!
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.

Yegor
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.