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
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.
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)
Maybe easy-hackable. The tooltip comes from ScFuncDesc and perhaps /sc/source/ui/app/inputwin.cxx is a start to look for code pointer.
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