Bug 93834 - CALC: Moving with arrows doesn't work when cells activated by double mouse click and '=' clicked
Summary: CALC: Moving with arrows doesn't work when cells activated by double mouse cl...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Edit-Mode
  Show dependency treegraph
 
Reported: 2015-09-01 10:04 UTC by Zeki Bildirici
Modified: 2023-05-29 04:59 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 Zeki Bildirici 2015-09-01 10:04:09 UTC
Hi,

Steps to reproduce in:

1- Activate a cell by mouse double click to enter edit mode
2- Click "=" to start formula syntax, then click the arrow keys to select other cells to form a formula for example (=A3*B5)

Current situation: Arrow keys doesn't work, only selection with mouse cursor&click is possible.

Expected situation: Arrow keys should be working.

PS: sorry for the bad title.


Best regards,
Zeki
Comment 1 raal 2015-09-01 15:59:58 UTC
Reproducible with Version: 5.1.0.0.alpha1+
Build ID: b2363e98af7b0281279617e43b8fec5b898b9120
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-08-26_00:57:35

Works OK in LibreOffice 3.5.0 ,Build ID: d6cde02 -> regression
Comment 2 Michael Weghorn 2015-09-01 19:04:46 UTC
(In reply to raal from comment #1)
> Reproducible with Version: 5.1.0.0.alpha1+
> Build ID: b2363e98af7b0281279617e43b8fec5b898b9120
> TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
> 2015-08-26_00:57:35
> 
> Works OK in LibreOffice 3.5.0 ,Build ID: d6cde02 -> regression

I planned to bibisect this. However I did not find a single version where moving to another cell using the keyboard worked after double-clicking into a cell and then pressing "=".

I also tried with OpenOffice.org 3.3.0 (Build:9567) and LibreOffice 3.5.0rc3 (Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735) from the "bibisect-releases" repository.

However, in all versions I looked at, moving to another worked fine when selecting the first cell using a single mouse click, i.e.:

1. Activate a cell by SINGLE mouse click
2. Click "=" to start formula syntax, then click the arrow keys to select other cells to form a formula for example (=A3*B5)


@raal: Could you possibly verify again whether it actually works in LibreOffice 3.5 after using a DOUBLE mouse click to select the first cell.


In general, I am not certain whether the described behaviour is actually a bug or whether the behaviour is OK as it is (I do not feel able to judge this...).
Comment 3 Robinson Tryon (qubit) 2015-12-14 05:32:51 UTC Comment hidden (obsolete)
Comment 4 Joel Madero 2015-12-15 06:44:52 UTC
I tested all the way back to 3.3 and the same behavior exists.
Comment 5 QA Administrators 2017-01-03 19:51:26 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2019-12-03 14:45:47 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-12-03 04:39:53 UTC Comment hidden (obsolete)
Comment 8 BogdanB 2023-05-29 04:59:58 UTC
If cell editing it is started with F2, than =, arrows can be used.
When cell editing it is started with double click, then =, arrows can NOT be used.

Retested with
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 3070091c9eafc964ebb3f53d3b44124b40571fd8
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded