https://bugs.documentfoundation.org/show_bug.cgi?id=151701
Bug ID: 151701
Summary: Enable acceptance of the suggestion when entering
formulas also with Tab (Tabulator) key
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
