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 220.127.116.11, 18.104.22.168+ (Build ID: f27f13b8e8865f0e39fbb9489ed1c0b65857b90)
On the master I get a crash on the step 7 (Version 22.214.171.124.alpha0+ (Build ID: 5a9b1bcc3941574f0f42791c189f90b302816da), will file another bug report for that.
Best regards. JBF
I also reproduce this behaviour on Win 7 Home Premium with LO 126.96.36.199 and LO 188.8.131.52+ (Build ID: 0977ba31ee91f2ccaef87883407a3d3700e7551) except I have no background on cell G1.
Confirmed using Xubuntu 12.04 + LibO 184.108.40.206 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)
- debian squeeze + LO 220.127.116.11 (See screenshots)
- win7 - LO 18.104.22.168
Created attachment 75094 [details]
Created attachment 75095 [details]
First reopening the document
Created attachment 75096 [details]
Second reopening the document
Could not reproduce in 22.214.171.124, 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 ***