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)
Version:
(earliest affected)
4.0.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
initial input (267.08 KB, image/png)
2013-02-19 08:16 UTC, Agnès Rambaud 		Details
First reopening the document (324.20 KB, image/png)
2013-02-19 08:18 UTC, Agnès Rambaud 		Details
Second reopening the document (326.62 KB, image/png)
2013-02-19 08:19 UTC, Agnès Rambaud 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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