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 2014/12/04 13:22:08 UTC

[Bug 57307] New: removeMergedRegion() throws IndexOutOfBoundsException on .xlsx MS-Excel file

https://issues.apache.org/bugzilla/show_bug.cgi?id=57307

            Bug ID: 57307
           Summary: removeMergedRegion() throws IndexOutOfBoundsException
                    on .xlsx MS-Excel file
           Product: POI
           Version: 3.10-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: pulikkot@aol.com

Created attachment 32259
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32259&action=edit
removeMergedRegion tested excel

removeMergedRegion() throws an IndexOutOfBoundsException on .xlsx file. But is
working on .xls file

Here I have pasted the tested the code 

void removeRow(Sheet sheet){
    if(sheet){
        for(i in sheet.getFirstRowNum()..sheet.getLastRowNum()){
            Row row = sheet.getRow(i)
            if(!row){
                continue
            }
            for(j in row.getFirstCellNum()..row.getLastCellNum()){
                if(j<0){
                    continue
                }
                sheet.removeMergedRegion(j)
            }
            sheet.removeMergedRegion(i)
            sheet.removeRow(row)
        }
    }
}

-- 
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 57307] removeMergedRegion() throws IndexOutOfBoundsException on .xlsx MS-Excel file

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57307

Andreas Beeker <an...@gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |WONTFIX
                 OS|                            |All

--- Comment #1 from Andreas Beeker <an...@gmx.de> ---
Merged regions aren't addressed via the row/cell index.

Although I think the handling in the hssf method
InternalSheet.removeMergedRegion() is wrong and it actually should throw an
IOOB, I won't fix this handling, as it potentially breaks (a lot of) user code.

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