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)
(earliest affected) release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
Keywords: bibisected, regression
Depends on:
Blocks: Shortcuts-Mac
  Show dependency treegraph
Reported: 2017-07-02 21:16 UTC by bintoro
Modified: 2024-03-25 03:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description bintoro 2017-07-02 21:16:02 UTC
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 

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.

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-

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 

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

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

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
Comment 9 Noah Glenn 2021-02-21 11:52:48 UTC
This problem is still present.
Comment 10 Rick Collins 2022-03-25 18:36:03 UTC
The problem is still present.  It also interferes with editing or adding a reference to a cell immediately adjacent to the cell being edited. If the formula is large enough, the editing field over the cell being edited blocks viewing the adjacent cells.  This makes it impossible to click on it with the cursor.  Without being able to use the arrow keys to select the cell, the only choice remaining is to type the cell reference manually. 

I would have expected this to not take so long to fix.  I'm sure this impacts a lot of users and is rather a headache.
Comment 11 QA Administrators 2024-03-25 03:13:22 UTC
Dear kalle,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword

Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team