Bug 29653 - overlapping MergedRegions broken
Summary: overlapping MergedRegions broken
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-FINAL
Hardware: All All
: P3 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2004-06-17 22:18 UTC by Stefan Proels
Modified: 2004-11-16 19:05 UTC (History)
0 users

Java test case (870 bytes, text/plain)
2004-06-17 22:20 UTC, Stefan Proels
Excel file produced by POI 2.5 (4.50 KB, application/octet-stream)
2004-06-17 22:22 UTC, Stefan Proels

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Proels 2004-06-17 22:18:57 UTC
Here is a simple test case which creates 5x5 table and adds 2 merged regions
which cross each other. The resulting Excel file is displayed as expected by
OpenOffice 1.1.1. Using Excel, however, the complete table becomes merged. I've
tried with POI 2.0 and 2.5. The version of Excel I'm using is Excel 2002 from
Office XP. When the test case is modified so that the regions do not overlap,
the result looks fine.
Comment 1 Stefan Proels 2004-06-17 22:20:48 UTC
Created attachment 11877 [details]
Java test case
Comment 2 Stefan Proels 2004-06-17 22:22:00 UTC
Created attachment 11878 [details]
Excel file produced by POI 2.5
Comment 3 Stefan Proels 2004-06-18 01:05:49 UTC
I've tried to create overlapping regions directly in Excel it is seams it just
can't do that (while OpenOffice can). So this isn't a POI bug. Sorry for the