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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
 
Reported: 2018-12-11 15:42 UTC by raal
Modified: 2023-01-14 16:10 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

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
Description:
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  4.0.0.3

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

Version: 6.1.3.2
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
Comment 6 QA Administrators 2021-01-04 04:05:31 UTC Comment hidden (obsolete)
Comment 7 Roman Kuznetsov 2021-01-13 17:14:30 UTC
still repro in

Version: 7.2.0.0.alpha0+ (x64)
Build ID: 94f6765d6ecc3145fa2d266231124003cf953118
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL

but I'm not sure it's a bug

Mike, what do you think here?
Comment 8 Mike Kaganski 2021-01-13 17:38:03 UTC
IMO this is entirely up to UX to decide. It is about "what to do in some UI action"; it needs a decision and understanding what to do e.g. with values in hidden cells that should become visible, etc. No personal opinion what's "correct" (= fits most).
Comment 9 QA Administrators 2023-01-14 03:25:46 UTC Comment hidden (obsolete)
Comment 10 raal 2023-01-14 16:10:21 UTC
Still repro Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f65d7fb18c5b850a381727a67c97fc94128082d2
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded