Download it now!
Bug 94929 - Selection stays current location even after selecting or modifying a cell outside selection
Summary: Selection stays current location even after selecting or modifying a cell out...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.2.2 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Selection
  Show dependency treegraph
 
Reported: 2015-10-10 11:33 UTC by B.J. Herbison
Modified: 2020-01-29 17:06 UTC (History)
1 user (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 B.J. Herbison 2015-10-10 11:33:42 UTC
Steps to reproduce:

1) Open or create a spreadsheet document with named range.
2) Search for text only occurring outside the range.
3) select the name from the drop down list at the top left and press Enter.
4) Click the "find next" down arrow in the search bar.
5) Press F2 to edit the cell located by the search.
6) Press enter (after optionally editing the cell).

Expected:
* Focus is in cell below the edited cell.

Actual:
* Focus is in a cell in the named range.

Observed with 4.4.2.2 on Ubuntu. Reproduced with 5.0.2.2 on Windows 7.
Comment 1 Buovjaga 2015-10-10 13:42:40 UTC
Reproduced.

Win 7 Pro 64-bit, Version: 5.0.2.2 (x64)
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale: fi-FI (fi_FI)
Comment 2 QA Administrators 2016-11-08 11:36:10 UTC Comment hidden (obsolete)
Comment 3 B.J. Herbison 2016-11-08 12:28:58 UTC
Still present on 5.2.3.3 on Windows 7.
No observed change in behavior.
Comment 4 Gilward Kukel 2017-01-14 04:46:32 UTC
still present in 5.2.4.2

The problem is that the current cell can be outside of the selected cells.
That can also be achieved this way:
1. go to A1
2. press Shift+Right
3. press TAB
4. press Shift+Left
A1 is selected but A2 is the current cell.
Comment 5 QA Administrators 2018-07-17 02:39:47 UTC Comment hidden (obsolete)
Comment 6 B.J. Herbison 2018-07-17 10:14:45 UTC
Tested with 6.0.3.2. Both the behavior in the original report and the behavior in comment 4 still exist.
Comment 7 QA Administrators 2019-07-18 02:49:28 UTC Comment hidden (obsolete)
Comment 8 B.J. Herbison 2019-07-19 11:17:02 UTC
Tested with 6.2.5.2. Both the behavior in the original report and the behavior in comment 4 still exist.

Version: 6.2.5.2
Build ID: 1:6.2.5-0ubuntu0.18.04.1~lo1
CPU threads: 12; Linux 5.0; UI render: default: VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 9 B.J. Herbison 2020-01-29 17:06:32 UTC
Still present in 6.3.4.2.