Bug 29653

Summary:	overlapping MergedRegions broken
Product:	POI	Reporter:	Stefan Proels <stefan.proels>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED INVALID
Severity:	critical
Priority:	P3
Version:	2.0-FINAL
Target Milestone:	---
Hardware:	All
OS:	All
Attachments:	Java test case Excel file produced by POI 2.5

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