Bug 119423 - CTRL+D leads to invalid merged cells that are not selectable and are not saved
Summary: CTRL+D leads to invalid merged cells that are not selectable and are not saved
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2018-08-22 13:52 UTC by OfficeUser
Modified: 2023-05-19 03:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
CTRL+D_merged.ods (6.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-22 13:53 UTC, OfficeUser
Details

Note You need to log in before you can comment on or make changes to this bug.
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)