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: 2024-01-31 11:58 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.
Comment 10 QA Administrators 2022-01-29 03:54:47 UTC Comment hidden (obsolete)
Comment 11 B.J. Herbison 2022-01-29 20:56:11 UTC
I see this problem every day.

This bug is still present with:
Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.2
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: CL

I'd be glad to test with a newer version if you would provide me with a coherent set of installation instructions.

The first place I looked (https://www.libreoffice.org/get-help/install-howto/linux/) say to use the version from my OS. How to I get a later version on Ununtu?

I then found https://wiki.documentfoundation.org/Documentation/Install/Linux and the "Graphic Installation (Preferred Way)" failed. From the command line instruction it says that Ubuntu should use .deb files, but the kit that the download page gave me (the link from https://www.libreoffice.org/download/download/ ) contains rpm files.

Can you just give me either an installation program to run or a tar file I can extract and just run the file in the extracted directory?
Comment 12 Buovjaga 2022-01-29 21:10:27 UTC
One way is to add the PPA offered by the Ubuntu packaging team: https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

sudo add-apt-repository ppa:libreoffice/ppa
sudo apt-get update

An easy way is to use an appimage: https://libreoffice.soluzioniopen.com/
Unfortunately the appimage site is down at the moment.
Comment 13 B.J. Herbison 2022-01-29 22:06:02 UTC
Thank you for the reply. I added the ppa and used apt-get update and apt-get upgrade and nothing was installed. I'm still at 6.2.5.2.

And https://libreoffice.soluzioniopen.com isn't responding for me either.

If you want me to confirm the bug still exists on a newer version I still need additional instructions.
Comment 14 Buovjaga 2022-01-30 07:10:13 UTC
Sorry, I should have sought out better instructions for you: https://ubuntuhandbook.org/index.php/2022/01/libreoffice-7-2-5-released/

I don't use Ubuntu myself.

Btw. now the appimage site is back.
Comment 15 B.J. Herbison 2022-01-30 18:03:59 UTC
Thank you for your help, I now have an updated version.

This bug is still present in:
Version: 7.2.5.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.2.5-0ubuntu0.21.10.1
Calc: threaded
Comment 16 QA Administrators 2024-01-31 03:13:50 UTC Comment hidden (obsolete)
Comment 17 B.J. Herbison 2024-01-31 11:58:19 UTC
The reported problem is still present in 7.6.4.1.

Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 16; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.6.4-0ubuntu0.22.04.1~lo1
Calc: threaded