merged cells become unmerged when deleting first row or column
Steps to Reproduce:
menu Sheet - Delete Columns
merged cell range will remain
User Profile Reset: No
Tested with LO 6.3 and LO 184.108.40.206
see also https://bugs.documentfoundation.org/show_bug.cgi?id=31805
Thank you for reporting the bug. I can confirm that the bug is present in
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 2; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: group threaded
inherited from OOo
but i am not sure if this is a bug:
B1 and C1 are merged into A1, so deleting Column A will undo the merge
to make it visible: select column A -> A1:C and A2:A1048576 are selected
deleting column B or C will keep the merge.
It works in Gnumeric and Excel- deleting column A keeps the merge
I'm not an expert, nut in my opinion if I decided to merge A1:A3 and then to delete a column with merge cells it is logic to delete everything on that column, includind merge cell or other things. And column B to became the first row.
So, I think this is not a bug. I don't understand Excel logic on this problem: I have a column and I delete a column with some changes, and changes remains? Why?
Eike, please say us your opinion