https://bz.apache.org/bugzilla/show_bug.cgi?id=56454
--- Comment #2 from Javen O'Neal <[email protected]> --- Created attachment 33328 --> https://bz.apache.org/bugzilla/attachment.cgi?id=33328&action=edit Progress towards a fix Upon closer inspection, handling of sheet shifting has several issues besides ignoring merged regions that don't include the first column. Depending on the shifted rows, merged regions may shift (if the merged region is fully contained inside the source move rows), shrink from the top if the first row is a source row and the shift direction is down, shrink from the bottom if the last row is a source row and the shift direction is up, expand from the top if the first row is a source row and the shift direction is up, expand from the top if the last row is a source row and the shift direction is down, or remove the merged region if there is a conflict (merged region in destination or some of merged regions from the source are moved outside the merged region). The current code only handles the first case, where the entire merged region shifts. I've updated XSSFRowShifter to handle most of these cases. Many more unit tests are needed before this can be committed, then the logic in XSSFRowShifter.shiftMerged can be copied over to HSSFSheet. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
