Bug 108911 - Cannot toggle cursor focus between formula and worksheet
Summary: Cannot toggle cursor focus between formula and worksheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.4.2 release
Hardware: All Mac OS X (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks: Shortcuts-Mac
  Show dependency treegraph
 
Reported: 2017-07-02 21:16 UTC by kalle
Modified: 2019-04-20 18:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
bibisect log (4.16 KB, text/plain)
2018-04-07 20:55 UTC, eisa01
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kalle 2017-07-02 21:16:02 UTC
Description:
In OpenOffice, while editing a formula, I was able to hit F2 to toggle the focus between the formula and the worksheet. When the focus was on the worksheet, the selected cell would be inserted in the formula as a reference. This allowed for easy creation of cell references via keyboard navigation (as opposed to clicking on the desired cell using the mouse).

This doesn't seem to work in LibreOffice. Entering cell references via keyboard navigation is only possible right after a new formula is created by hitting "=". As soon as the navigation focus is moved to the formula itself, there seems to be no way to move it back to the worksheet.



Steps to Reproduce:
1. Hit F2 to begin editing a formula.
2. Hit F2 again.
3. Use the arrow keys to move the cursor.


Actual Results:  
The cursor that moves is the one in the formula editor.


Expected Results:
The cell cursor moves. A reference to the selected cell is inserted into the formula.



Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:55.0) Gecko/20100101 Firefox/55.0
Comment 1 Alex Thurgood 2017-07-05 11:54:14 UTC
@lkjt : when I tried testing this on 

Version: 5.3.4.2
Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3
Threads CPU : 4; Version de l'OS :Mac OS X 10.12.5; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

the F2 key switched between expanded and minimized display of the function wizard.

If I use F2, after clicking on a cell to select it, I enter formula definition mode, however, I can not then switch back to the sheet in order to navigate via the keyboard to the cell I wish to include in my formula.

Confirming
Comment 2 Alex Thurgood 2017-07-05 11:55:01 UTC
If this is still in ApacheOpenOffice, then for us it is either a regression or a deprecated feature.
Comment 3 Alex Thurgood 2017-07-05 12:10:32 UTC
Tested with 

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

where switching with F2 reduces the function wizard window and allows navigation with cursor keys to select cell.
Comment 4 Alex Thurgood 2017-07-05 12:18:41 UTC
Confirming that the toggle only works the very first time with 

Version: 5.3.4.2
Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3
Threads CPU : 4; Version de l'OS :Mac OS X 10.12.5; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

Setting as regression
Comment 5 eisa01 2018-03-29 21:08:41 UTC
Still present

Version: 6.1.0.0.alpha0+
Build ID: a488c7ad2763b944713997911c1ddb0315d8c93f
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-26_00:38:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 6 eisa01 2018-04-07 20:55:59 UTC
Created attachment 141199 [details]
bibisect log

Bibisected, see log
Comment 7 QA Administrators 2019-04-08 02:46:08 UTC Comment hidden (obsolete)
Comment 8 eisa01 2019-04-20 18:18:15 UTC
This is still present

Version: 6.3.0.0.alpha0+
Build ID: ea9c13be02ba731074fa4207944ff7df40a0fb5c
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-04-10_20:43:17
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded