poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 46009] New: Cloning sheet with merged region causes ArrayStoreException when saving.
Date Wed, 15 Oct 2008 03:34:02 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46009

           Summary: Cloning sheet with merged region causes
                    ArrayStoreException when saving.
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Mac OS X 10.4
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: prescindor@gmail.com


Created an attachment (id=22730)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=22730)
A test case that clones sheets with and without a merged region.

If you clone a sheet that has a merged region, you get an exception when you
attempt to write the workbook:

$ run
There is 1 sheet.
There are 2 sheets.
Worked for: noMergedRegion
There is 1 sheet.
There are 2 sheets.
Failed for: hasMergedRegion
java.lang.ArrayStoreException
        at java.lang.System.arraycopy(Native Method)
        at java.util.ArrayList.toArray(ArrayList.java:304)
        at
org.apache.poi.hssf.record.aggregates.MergedCellsTable.visitContainedRecords(MergedCellsTable.java:85)
        at
org.apache.poi.hssf.model.Sheet.visitContainedRecords(Sheet.java:577)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1319)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1229)
        at TestCase.test(TestCase.java:30)
        at TestCase.main(TestCase.java:10)

Code to reproduced the above is attached.

Workaround: Remove all the merged regions from the cloned sheet. Then loop over
the merged regions in the original sheet and add each one found to the cloned
sheet. The resulting workbook saves without a problem.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


Mime
View raw message