Bug 122024 - merged cells become unmerged when deleting first row or column
Summary: merged cells become unmerged when deleting first row or column
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
Reported: 2018-12-11 15:42 UTC by raal
Modified: 2019-01-04 19:17 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description raal 2018-12-11 15:42:35 UTC
merged cells become unmerged when deleting first row or column 

Steps to Reproduce:
open spreadsheet
merge A1:C3
click A5
menu Sheet - Delete Columns

Actual Results:
Merge lost

Expected Results:
merged cell range will remain

Reproducible: Always

User Profile Reset: No

Additional Info:
Tested with LO 6.3 and LO

see also https://bugs.documentfoundation.org/show_bug.cgi?id=31805
Comment 1 Durgapriyanka 2018-12-11 17:31:42 UTC
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
Comment 2 Oliver Brinzing 2018-12-11 18:24:24 UTC
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.
Comment 3 raal 2018-12-11 19:54:48 UTC
It works in Gnumeric and Excel- deleting column A keeps the merge
Comment 4 BogdanB 2018-12-11 20:29:33 UTC
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?
Comment 5 Roman Kuznetsov 2019-01-04 19:17:16 UTC
Eike, please say us your opinion