Bug 151701 - Enable acceptance of the suggestion when entering formulas also with Tab (Tabulator) key
Summary: Enable acceptance of the suggestion when entering formulas also with Tab (Tab...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: easyHack, needsDevEval
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2022-10-22 12:35 UTC by Jürgen Kirsten
Modified: 2024-05-21 06:39 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 Jürgen Kirsten 2022-10-22 12:35:47 UTC
Description:
It should be possible to accept the suggestion with the Tab key when entering formulas. This is the standard in Excel spreadsheets. Acceptance with Enter does not work there. 
In the Google Sheets spreadsheet, it is possible to accept the suggestion with the Enter key as well as with the Tab key. 
In LibreOffice Calc, the proposal can only be accepted with the Enter key. 

Since I work with Calc and Excel (for business), this often leads me to use the wrong key. Most of the time the problem is with Calc. In addition, in Calc you can scroll through the suggestions by pressing CTRL + Tab. You are already there with the Tab key, so it makes sense to be able to take over with the Tab key as well. 

In order not to completely confuse long-time Calc users, I would wish that the transfer can be carried out with Enter as well as with the Tab key, just as with Google Sheets.

Steps to Reproduce:
1. Start writing a formula in a cell. For example =ind 
   Calc suggests two functions. Index and Indirect. 
2. You can switch between the two suggestions with CTRL + Tab.
3. When you have reached your desired function, for example Indirect, you want to accept this suggestion with the Tab key, as in Excel or in Google Sheets.

Actual Results:
The cell to the right of the current one is jumped to and a #NAME? error appears in the edited cell because Calc cannot interpret the letters entered so far as a function.

Expected Results:
Calc should take the function name and place the cursor after the first bracket, just as when using the Enter key.


Reproducible: Always


User Profile Reset: No

Additional Info:
My System for Testing :
Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-GB (de_DE); UI: en-GB
Calc: threaded
Comment 1 stefandeutsch2 2022-10-31 11:54:55 UTC
That would be great. With Enter, Calc jumps into the next line, but often it would be good to go to the next cell with the Tabulator.
Comment 2 Richard Kraut 2022-10-31 17:55:05 UTC
I suggest expanding the settings for Calc in the options menu so the users have the choice how it reacts.

For example:
* Calc classic (LibreOffice Calc just do anyting like the other/older versions before)
* Excel (LibreOffice Calc does nearly everthing like Microsoft Excel)
* Google Sheets (LibreOffice does nearly everything like Google Sheets)
* Custom (The user can customize functions/reactions in Calc)
Comment 3 Heiko Tietze 2022-11-02 12:43:26 UTC
Maybe easy-hackable. The tooltip comes from ScFuncDesc and perhaps /sc/source/ui/app/inputwin.cxx is a start to look for code pointer.
Comment 4 Jürgen Kirsten 2024-05-20 16:06:39 UTC
Unfortunately, this extension of the functionality for the transfer when entering functions has still not been implemented.

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

Today I realised that the EXCEL web version now also accepts both keys. You can also use TAB or ENTER to transfer the function there. 

Only in CALC only the ENTER key is accepted. That is a pity.

If this is a simple hack, it could be implemented in the short term.

Kind regards 

Jürgen