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 2015/06/22 21:34:45 UTC

[Bug 58070] New: Can't add two merge cells (XSSF)

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

            Bug ID: 58070
           Summary: Can't add two merge cells (XSSF)
           Product: POI
           Version: 3.12-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: nicedelamontagne@gmail.com

Created attachment 32849
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32849&action=edit
To reproduce bug

I create a file and I need to merge cells. After I need to merge a second time
with 2 new columns. 

When you open the file xlsx there is an error's message and Excel need to
repair the file. In fact, the second merge is deleted.

The problem doesn't exist with HSSF.

-- 
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 58070] [PATCH] Can't add two merge cells (XSSF)

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

Michiel <mi...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Can't add two merge cells   |[PATCH] Can't add two merge
                   |(XSSF)                      |cells (XSSF)

-- 
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 58070] [PATCH] Can't add two merge cells which overlap

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|[PATCH] Can't add two merge |[PATCH] Can't add two merge
                   |cells (XSSF)                |cells which overlap

-- 
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 58070] [PATCH] Can't add two merge cells (XSSF)

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

--- Comment #3 from David North <dt...@corefiling.co.uk> ---
Thanks for the patch. Please can you supply some unit tests to demonstrate what
didn't work previously and now does?

-- 
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 58070] Can't add two merge cells (XSSF)

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

--- Comment #1 from Michiel <mi...@gmail.com> ---
Looks like the method should merge any merged cell ranges that overlap. At
least that seems to be the behavior in Excel itself.

-- 
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 58070] [PATCH] Can't add two merge cells (XSSF)

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

David North <dt...@corefiling.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

-- 
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 58070] [PATCH] Can't add two merge cells which overlap

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

Javen O'Neal <on...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |DUPLICATE
             Status|NEEDINFO                    |RESOLVED

--- Comment #5 from Javen O'Neal <on...@apache.org> ---
No response for several months. I assume that this was fixed with bug 58443.
Please reopen if this problem has not been resolved.

*** This bug has been marked as a duplicate of bug 58443 ***

-- 
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 58070] Can't add two merge cells (XSSF)

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
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 58070] [PATCH] Can't add two merge cells (XSSF)

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |PatchAvailable

-- 
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 58070] [PATCH] Can't add two merge cells (XSSF)

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

--- Comment #4 from Javen ONeal <ja...@gmail.com> ---
I think this is a duplicate of bug 58443. I deployed the fix for that bug to
trunk. Could you test your code against a nightly build of POI (the first build
with the fix is #924).

-- 
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 58070] Can't add two merge cells (XSSF)

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

--- Comment #2 from Michiel <mi...@gmail.com> ---
Created attachment 32906
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32906&action=edit
Patch file

This patch aims to merge overlapping merged regions so that Excel does not
consider the file to be corrupt.

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