Bug 134751 - Cell access error when merged cell is duplicated
Summary: Cell access error when merged cell is duplicated
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
Reported: 2020-07-12 15:41 UTC by BDF
Modified: 2023-10-22 18:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

bug in detail (71.33 KB, image/png)
2020-07-12 15:42 UTC, BDF
ods file for bug (8.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-12 15:42 UTC, BDF
video with the bug (1.80 MB, video/mp4)
2020-07-12 17:25 UTC, BogdanB

Note You need to log in before you can comment on or make changes to this bug.
Description BDF 2020-07-12 15:41:29 UTC
When you merge cells (eg. A1, B1 and C1) and duplicate them in A2 the cells overlap each other. You have the merged cell which's content covers B2 and C2, but you can also select A2 and C2 on it's own and add content to them.

Steps to Reproduce:
1. Select multiple cells (eg. A1, B1 and C1) and merge them
2. Select A2 and press Ctrl + D to duplicate the cell

Actual Results:
The existing merged cell is duplicated and overlaps B2 and C2, however you can also still select B2 and C2 and add data to them

Expected Results:
The merge cell (A1 to C1) is duplicated in A2 to C2 and covers the whole area of all three cells. B2 and C2 are not selectable with arrow key or with the mouse

Reproducible: Always

User Profile Reset: No

Additional Info:
Cell selection (with arrow keys, mouse works as well) in attached image:
1) Select merged cell A1-C1
2) press right once to get to D1
3) Select the duplicate of the merged cell at A2
4) press right once to get to B2
5) press right once to get to C2

Important NOTE for attached .ods file: Closing and reopening the file seems to clear the bug, so I guess the cell is saved correctly, but displayed wrong. To get the described bug just select A2 and press Ctrl + D.

Version: (x64)
Build-ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU-Threads: 6; BS: Windows 6.1 Service Pack 1 Build 7601; UI-Render: Standard; VCL: win; 
Gebietsschema: de-AT (de_AT); UI-Sprache: de-DE
Calc: CL
Comment 1 BDF 2020-07-12 15:42:22 UTC
Created attachment 162928 [details]
bug in detail
Comment 2 BDF 2020-07-12 15:42:45 UTC
Created attachment 162929 [details]
ods file for bug
Comment 3 BogdanB 2020-07-12 17:24:58 UTC
I confirm the behavior, what you describe is correct. what I don't know if this is a bug or not. Because E and F in my video are still there after unmerge...

I didn't find a place with the description for the right behavior for Ctrl + D.

Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US
Calc: threaded
Comment 4 BogdanB 2020-07-12 17:25:40 UTC
Created attachment 162931 [details]
video with the bug

I am not sure it's a bug, but if YES thiv video could be useful.
Comment 5 QA Administrators 2022-07-13 03:30:18 UTC Comment hidden (obsolete)
Comment 6 BDF 2022-07-17 20:47:29 UTC
(In reply to QA Administrators from comment #5)
> Dear BDF,
> [...]
> Warm Regards,
> QA Team

Dear QA Administrators,

Yes the bug still exists as described and can be reproduced without any big effort in LibreOffice calc

Version: / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: de-AT (de_AT.UTF-8); UI: de-DE
Calc: threaded

Operating System: KDE neon 5.25
KDE Plasma Version: 5.25.2
KDE Frameworks Version: 5.96.0
Qt Version: 5.15.5
Kernel Version: 5.13.0-52-generic (64-bit)
Graphics Platform: X11
Processors: 16 × AMD Ryzen 7 4800H with Radeon Graphics
Memory: 30.8 GiB of RAM
Graphics Processor: AMD RENOIR
Manufacturer: Micro-Star International Co., Ltd.
Product Name: Bravo 17 A4DDR
System Version: REV:1.0

Since the bug is over a year old I most certainly tried this on my Windows machine. I will add another comment when I tested it on Windows. Since the same bug exists on Linux, I expect the bug to still exist in Windows.