Bug 127740 - While editing, left key selects the previous cell on the left
Summary: While editing, left key selects the previous cell on the left
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-24 10:47 UTC by Szasz-Fabian Jozsef
Modified: 2020-04-24 19:11 UTC (History)
4 users (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 Szasz-Fabian Jozsef 2019-09-24 10:47:49 UTC
Description:
If I double click or F2 on a cell to edit it, I can move the cursor left or right with the arrow keys. However, if I select a blank cell and start typing it, then hit the left key to move back, it selects the previous cell on the left instead! I am looking to get rid of this functionality since it's very annoying and counter-productive.

Steps to Reproduce:
1. Select an empty cell
2. Type 'JohnSmith'
3. Hit the left key to go between 'nS' to add the missing space

Actual Results:
Calc leaves the cell being edited and jumps to the previous cell on the left.

Expected Results:
Move the cursor. Since I'm not typing a formula (started with =), I'm not interested to pick another cell.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Xisco Faulí 2019-09-25 15:27:36 UTC
Hello Miguel Angel,
Do you know if it's possible to move the cursor backwards? I've tried with Scroll Lock as suggested here < https://ask.libreoffice.org/en/question/87678/cursor-keys-scroll-document-in-calc-instead-of-moving/ > but it doesn't work for me...
Comment 2 Oliver Brinzing 2019-09-25 17:38:53 UTC
already reproducible with AOO 4.1.5, but works same way as excel 2016
for me this is not a bug.
Comment 3 m_a_riosv 2019-09-25 20:47:02 UTC
(In reply to Xisco Faulí from comment #1)
> Hello Miguel Angel,
> Do you know if it's possible to move the cursor backwards? I've tried with
> Scroll Lock as suggested here <
> https://ask.libreoffice.org/en/question/87678/cursor-keys-scroll-document-in-
> calc-instead-of-moving/ > but it doesn't work for me...
Hi Xisco, Scroll Lock it's for move the cell when activated instead of change the cell with the arrow keys, although seems in some Linux it's an issue because it's used to change the keyboard layout. 
I think has nothing to do with this issue.

The reported behavior it's only available for me when the cell begins with an '=' that implies usually a formula is going to be written, but can be a bit annoying if the formula has text and you want to move the cursor for correct something.

But I don't think can be a bug, maybe some improvement can be done.
Comment 4 Buovjaga 2020-04-24 19:11:25 UTC
If this was changed, we would get a million people complaining about the changed behaviour. Closing.