Bug 61024

Summary:	Calc does not love to have several merged cells with comment on the same row
Product:	LibreOffice	Reporter:	Jean-Baptiste Faure <jbfaure>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	fdbugs, lgodard.libre, miguelangelrv
Priority:	medium
Version:	4.0.0.3 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=61025 https://bugs.freedesktop.org/show_bug.cgi?id=56279 https://bugs.freedesktop.org/show_bug.cgi?id=56294
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	initial input First reopening the document Second reopening the document

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 4.0.0.3, 4.0.1.0+ (Build ID: f27f13b8e8865f0e39fbb9489ed1c0b65857b90)
On the master I get a crash on the step 7 (Version 4.1.0.0.alpha0+ (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 4.0.0.3 and LO 4.0.1.0+ (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 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)

Comment 3 Agnès Rambaud 2013-02-19 08:15:09 UTC

Confirmed using 
- debian squeeze + LO 4.0.0.3 (See screenshots)
and
- win7 - LO 3.6.4.3

Agnès

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.3.4.1, 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 ***