Bug 53472

Summary: RegionUtil Borders Lost Under Certain Conditions.
Product: POI Reporter: Alan Hay <alanhay99>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P2    
Version: 3.8-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Attachments: Example to recreate the issue.

Description Alan Hay 2012-06-26 19:53:03 UTC
Created attachment 28999 [details]
Example to recreate the issue.

Kind of hard to explain but can be clearly seen by running the attached example.

If a merged region is added to the workbook which spans multiple rows and these rows have not yet been added via sheet.createRow(), the borders around the merged region are lost when a row is added to the sheet with the same row index as the lower bound of the merged region.

Affects both HSSF and XSSF workbooks.

Creating the merged region after all rows have been added shows the expected behaviour.
Comment 1 Alan Hay 2012-06-26 20:19:25 UTC
Okay, excuse my stupidity.

There is no need to call createRow() after the merge as the rows have already been inserted by the merge operation.