Bug 61024 - Calc does not love to have several merged cells with comment on the same row
Summary: Calc does not love to have several merged cells with comment on the same row
Status: RESOLVED DUPLICATE of bug 56279
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-02-17 19:36 UTC by Jean-Baptiste Faure
Modified: 2015-01-13 06:58 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

initial input (267.08 KB, image/png)
2013-02-19 08:16 UTC, Agnès Rambaud
First reopening the document (324.20 KB, image/png)
2013-02-19 08:18 UTC, Agnès Rambaud
Second reopening the document (326.62 KB, image/png)
2013-02-19 08:19 UTC, Agnès Rambaud

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Baptiste Faure 2013-02-17 19:36:38 UTC
Steps to reproduce:
1/ open a new spreadsheet
2/ select cells A1:B1 and click on merge and center button; add a background color to the merged cell to make it more visible
3/ repeat step 2 with cells D1:E1 and another background color.
4/ save the file and reload it ==> it opens fine and looks OK.
5/ add a comment on the first merged cell
6/ save and reload ==> OK
7/ add a comment on the second merged cell
8/ save and reload ==> now the first merged cell is unchanged but the second is destroyed: the second comment is on D1 which is not merged and the merged cell has been moved to G1:H1; both cells D1 and G1 have the background color of the original second merged cell.

tested on versions, (Build ID: f27f13b8e8865f0e39fbb9489ed1c0b65857b90)
On the master I get a crash on the step 7 (Version (Build ID: 5a9b1bcc3941574f0f42791c189f90b302816da), will file another bug report for that.

Best regards. JBF
Comment 1 Jacques Guilleron 2013-02-17 23:21:28 UTC
Hello JBF,

I also reproduce this behaviour on Win 7 Home Premium with LO and LO (Build ID: 0977ba31ee91f2ccaef87883407a3d3700e7551) except I have no background on cell G1.

Jacques Guilleron
Comment 2 Jean-Francois Nifenecker 2013-02-18 06:30:14 UTC
Confirmed using Xubuntu 12.04 + LibO (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)
Comment 3 Agnès Rambaud 2013-02-19 08:15:09 UTC
Confirmed using 
- debian squeeze + LO (See screenshots)
- win7 - LO

Comment 4 Agnès Rambaud 2013-02-19 08:16:57 UTC
Created attachment 75094 [details]
initial input
Comment 5 Agnès Rambaud 2013-02-19 08:18:19 UTC
Created attachment 75095 [details]
First reopening the document
Comment 6 Agnès Rambaud 2013-02-19 08:19:01 UTC
Created attachment 75096 [details]
Second reopening the document
Comment 7 Matthew Francis 2015-01-13 06:58:09 UTC
Could not reproduce in, 4.4 beta or 4.5 master
This is also most likely a duplicate of bug 56279

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