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.
[Reproducible] with "LibreOffice 3.3.0Beta3 - WIN XP DE [OOO330m9 (build 184.108.40.206)]"
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
actual OOo 3.4-dev: as expected
We should get the same behaviour as OOo 3.4
Created attachment 40446 [details]
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.
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":
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:
Affected users are encouraged to test the fix and report feedback.