| Summary: | setRowGroupCollapsed not implemented | ||
|---|---|---|---|
| Product: | POI | Reporter: | Ishmeet <sweeny121> |
| Component: | SXSSF | Assignee: | POI Developers List <dev> |
| Status: | NEW --- | ||
| Severity: | enhancement | ||
| Priority: | P2 | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Linux | ||
Note that the method implementation is fine in version 3.8-beta5 (http://grepcode.com/file/repo1.maven.org/maven2/org.apache.poi/poi-ooxml/3.8-beta5/org/apache/poi/xssf/streaming/SXSSFSheet.java#SXSSFSheet): public void setRowGroupCollapsed(int row, boolean collapse) { _sh.setRowGroupCollapsed(row, collapse); } But for some reason, this was commented out in version 3.8: public void setRowGroupCollapsed(int row, boolean collapse) { //_sh.setRowGroupCollapsed(row, collapse); throw new RuntimeException("Not Implemented"); } Here is the commit message: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java?view=diff&r1=1295057&r2=1295058&pathrev=1295058 FYI, in the meantime it was at least brought back for collapsing, but is still not there for uncollapsing:
public void setRowGroupCollapsed(int row, boolean collapse)
{
if (collapse) {
collapseRow(row);
} else {
//expandRow(rowIndex);
throw new RuntimeException("Not Implemented");
}
}
(In reply to Ishmeet from comment #1) > Here is the commit message: r1295058 |
I am using SXSSF for generating excel sheets. The method setRowGroupCollapsed has not yet been implemented in SXSSFSheet.class: public void setRowGroupCollapsed(int row, boolean collapse) { //_sh.setRowGroupCollapsed(row, collapse); throw new RuntimeException("Not Implemented"); } As a result, if I try to collapse rows, the excel sheet generated gives the error message: "Excel found unreadable content".