You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/11/16 16:46:32 UTC

[Bug 60384] New: ShiftRows unexpected deletion of mergedRegions (due to 59740)

https://bz.apache.org/bugzilla/show_bug.cgi?id=60384

            Bug ID: 60384
           Summary: ShiftRows unexpected deletion of mergedRegions (due to
                    59740)
           Product: POI
           Version: 3.15-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: regression
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: fabio.heer@dvbern.ch
  Target Milestone: ---

Created attachment 34455
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34455&action=edit
Template for use case

Due to https://bz.apache.org/bugzilla/show_bug.cgi?id=59740 merged regions are
disappearing even when no overlap was created.

Typical use case:
You have a template like attached with a merged region in row 9.
Row 3 is "template-row":
1. It either gets removed (no prameter)
2. Or it gets filled with just 1 parameter
3. Or it gets duplicated and filled for each parameter

Since I have to add or remove rows with sheet.shiftRows(3,
sheet.getLastRowNum(), n), the merged region in row 9 simply gets deleted.

Merged regions that do not create an overlap with another merged region should
not be deleted just like that. I expect the merged region to shift just like it
did in POI < 3.15

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

[Bug 60384] ShiftRows unexpected deletion of mergedRegions (due to 59740)

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60384

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |56454

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
This should be fixed again via r1805518, we now check differently if the merged
reagion is overwritten or moved along by the shifting, this should make these
cases work better.

Please note that there is discussion about a more complete implementation of
handling of merged regions in bug #56454.


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=56454
[Bug 56454] XSSFSheet.shiftRows(...) and HSSFSheet.shiftRows(...) incorrectly
handle merged regions that do not contain column 0.
-- 
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

[Bug 60384] ShiftRows unexpected deletion of mergedRegions (due to 59740)

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60384

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

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

[Bug 60384] ShiftRows unexpected deletion of mergedRegions (due to 59740)

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60384

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david.leniniven@amalto.com

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
*** Bug 60709 has been marked as a duplicate of this bug. ***

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

[Bug 60384] ShiftRows unexpected deletion of mergedRegions (due to 59740)

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60384

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |59740


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=59740
[Bug 59740] [PATCH] Sheet.shiftRows incorrectly shifts merged region on exists
merged region
-- 
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

[Bug 60384] ShiftRows unexpected deletion of mergedRegions (due to 59740)

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60384

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |yuwun@163.com

--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
*** Bug 61163 has been marked as a duplicate of this bug. ***

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