Bug 119423

Summary: CTRL+D leads to invalid merged cells that are not selectable and are not saved
Product: LibreOffice Reporter: OfficeUser <norbert.notz>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: aron.budea, buzea.bogdan, xiscofauli
Priority: medium    
Version: 4.1 all versions   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108252    
Attachments: CTRL+D_merged.ods

Description OfficeUser 2018-08-22 13:52:17 UTC
Hi,

LibreOffice supports to copy the contents and formattings from the cell above with CTRL+D. However this feature has a major issue with merged cells.


Please open the attached ods file.

- Make sure (if not already) that cell A3 selected

- Press CTRL+D, RETURN, CTRL+D, RETURN, CTRL+D, RETURN and so on several times


Now try to select the resulted yellow merged cell area. It is impossible to select it and edit it. Trying to click on it always A1 instead.

(On the right side beginning with F3 and below you find such a not selectable merged cell.)
Comment 1 OfficeUser 2018-08-22 13:53:28 UTC
Created attachment 144369 [details]
CTRL+D_merged.ods
Comment 2 OfficeUser 2018-08-22 14:06:16 UTC
I just found that these invalid merged cells are not saved. That's why contrary to my initial comment you won't find a pre-defined "buggy" area after opening the spreadsheet.
Comment 3 OfficeUser 2018-08-22 14:06:46 UTC Comment hidden (obsolete)
Comment 4 Xisco FaulĂ­ 2018-08-22 14:20:17 UTC
I can reproduce it back to

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

while in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

CTRL+D doesn't work...
Comment 5 OfficeUser 2018-08-23 08:02:22 UTC
CAN reproduce in
LibreOffice-4.1.6.2.help-x86_64.AppImage

CanNOT reproduce in
LibreOffice-3.5.0.3.help-x86_64.AppImage
because CTRL+d feature not implemented.

So it looks like this bug exists since the CTRL+d feature has been implemented.
Comment 6 QA Administrators 2019-09-02 09:29:39 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-09-02 03:52:26 UTC Comment hidden (obsolete)
Comment 8 BogdanB 2023-05-18 14:39:54 UTC Comment hidden (obsolete)
Comment 9 Aron Budea 2023-05-18 18:52:13 UTC Comment hidden (obsolete)