Bug 47818 - EDITING: extending selection after pasting selects from top left
Summary: EDITING: extending selection after pasting selects from top left
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
: 91409 (view as bug list)
Depends on:
Blocks: Shortcuts-Accelerators Cell-Selection
  Show dependency treegraph
Reported: 2012-03-24 13:29 UTC by oscar.0
Modified: 2023-04-24 06:04 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Screencast (30.92 KB, image/gif)
2023-04-20 08:08 UTC, Heiko Tietze

Note You need to log in before you can comment on or make changes to this bug.
Description oscar.0 2012-03-24 13:29:31 UTC
Steps to reproduce:
1. Open a new spreadsheet
2. Enter some string (e.g. "a") in some cell
3. Copy (Ctrl+C) that string
4. Move cursor (by clicking left mouse button or by using keyboard arrow keys) to some other cell (e.g. C3) a bit away from cell A1
5. Paste (Ctrl+V) copied string
6. Extend selection beyond current cell (C3 in present example) e.g. by pressing Shift+right (or any other of the up/down/left/right arrow keys)

Current behavior: New selection is B1:C3 (or A2:B3 for Shift+down etc.)
Expected behavior: Selection should be C3:D3 (or C3:C4 for Shift+down etc.)

Browser: Mozilla/5.0 (X11; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0
Comment 1 sasha.libreoffice 2012-06-18 06:12:11 UTC
Thanks for bugreport
reproduced in 3.3.4 and 3.5.4 on Fedora 64 bit
and in 3.5.2 on Windows 7 32 bit

What is interesting: msExcel 2007 behaves in such situation as expected.
Therefore this bug is done not for compatibility with Excel

Changing version to 3.3.4 as most early reproduced
Comment 2 A (Andy) 2014-10-11 22:31:41 UTC
Reproducible with LO (Win 8.1)

In step 2 write the "a" in cell A1 to get the same selected cells as in the result.
Comment 3 m_a_riosv 2015-05-20 14:16:48 UTC
*** Bug 91409 has been marked as a duplicate of this bug. ***
Comment 4 m_a_riosv 2015-05-20 14:20:56 UTC
*** Bug 89079 has been marked as a duplicate of this bug. ***
Comment 5 QA Administrators 2016-09-20 09:42:24 UTC Comment hidden (obsolete)
Comment 6 Charlie Ogier 2016-09-20 10:58:39 UTC
This bug is still present.
Linux Mint 18 Cinnamon 64bit with LO
Comment 7 Xisco Faulí 2017-06-12 11:12:16 UTC
Changing version back to the earliest affected version.
Comment 8 QA Administrators 2018-06-13 02:36:40 UTC Comment hidden (obsolete)
Comment 9 Thomas Lendo 2018-10-01 20:15:30 UTC
Still reproducible.

Build-ID: 89a60912bba7ffd6f65ea99f4664f343c5025c95
CPU-Threads: 4; BS: Linux 4.15; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: threaded
Comment 10 QA Administrators 2019-10-02 02:56:14 UTC Comment hidden (obsolete)
Comment 11 oscar.0 2020-02-10 09:43:34 UTC
Bug still present

Build ID: 6.4.0-2
CPU threads: 2; OS: Linux 5.5; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-GB
Calc: threaded
Comment 12 QA Administrators 2022-02-10 03:40:56 UTC Comment hidden (obsolete)
Comment 13 oscar.0 2022-02-10 04:54:57 UTC
Bug still present

Version: / LibreOffice Community
Build ID: 30(Build:3)
CPU threads: 2; OS: Linux 5.16; UI render: default; VCL: gtk3_kde5
Locale: en-US (en_US.UTF-8); UI: en-GB
Calc: threaded
Comment 14 Heiko Tietze 2023-04-20 08:08:36 UTC
Created attachment 186804 [details]

(In reply to oscar.0 from comment #13)
> Bug still present

Please elaborate, the screencast is what I understand from the report.
Comment 15 ady 2023-04-20 08:30:55 UTC
FWIW, for me this was repro in Windows up until LO 7.3, but not in 7.4.

The reporter is using Linux, though.
Comment 16 oscar.0 2023-04-24 05:40:13 UTC
Looks like the bug has been resolved. Thanks a lot!