Created attachment 40444 [details] Screenshot - Before and after deleting a column from merged cells With OO 3.3 we are able to insert and delete columns and rows in a merged cells in Calc. However, deleting a column or a row from merged cells results in the remaining cells not being merged anymore, also sometimes losing the existing text. Steps to recreate this: 1. Merge 3x3 cells. (Can be any no of cells) 2. Insert some text. (Not really required) 3. Delete a row or a column from the merged cell. 4. This will result in the remaining cells to lose out on the merged format. The text may also be deleted. This issue is not in the original OO 3.2/3.3 released by Sun/Oracle but is in GoOo/LibreOffice which has affected Ubuntu and other distros using GoOo. Confirming the issue in the latest LibreOffice 3.3 Beta 3. Issue existed in Windows version also. https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/558968
[Reproducible] with "LibreOffice 3.3.0Beta3 - WIN XP DE [OOO330m9 (build 3.2.99.2)]" You can compare different behaviour of various OOo and LibO versions using attached "sample.ods": 1. open "sample.ods" 2. click 'G1' 3. Menu 'edit -> Celete Cell - Delete entire Column' expected: Column with cell containing "g" will be deleted, a merged cell range will remain actual OOo 3.1.1: Impossible: Message "You can not delete merged ranges" actual LibO Beta3: column deleted, but merged cells range destroyed (as reported) actual OOo 3.4-dev: as expected We should get the same behaviour as OOo 3.4
Created attachment 40446 [details] sample document
Yup, sorry Saaz. I know you've been mailing me about this one. Now that we have a bug report for this one, I'll finally get this taken care of for 3.3.
This is a regression from OOo and I nominate this as a show stopper.
Found the cause and fixed it. It should be good to go for 3.3. http://cgit.freedesktop.org/libreoffice/calc/commit/?h=libreoffice-3-3&id=6683ad4daa97331d1ce06136421cd8ec56190b24
Verified - Closed - Sophie
*** Bug 57457 has been marked as a duplicate of this bug. ***
As as a comment to 57457, I can only reproduce if I delete the 1st row (if I merge 3x3 from A1 to C3). If I delete row 1, the content is deleted and the merge goes away. If I delete Rows 2 or 3, things seem fine. This may be as expected. Kohei - can I get your feedback on this?
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/23b6c876180b5fc7b124f8116a350a9b9066e1f6%5E%21 uitest for bug tdf#31805 It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.