LibreOffice Calc 7.5, Ubuntu 22.4, German keyboard – how to select function from autocomplete suggestions

[stueckl]

Hello forum,
I am at a loss … what is the shortcut to cycle through functions in Calc?
I do know, it isn’t Ctrl+(Shift+)Tab … those only jump to the next/previous sheet.
Anything with Alt, Shift or Control plus cursor/Enter/Tab keys I tried won’t work either (admittedly, I didn’t try all possible combinations).

A bit more context …

• Calc is open
• I am at a cell
• I start with typing … =cou
• auto completion suggests “[COUNT], CountA, … and # other”
• I can select “Count” with enter

But how do I move the marker (“[]”) to “CountA”?

greets Peter

PS: as a side note … Ctrl+(Shift+)Tab does navigate forth and back the AutoInput values … but only if there is more than one value to choose from … if there’s only one, Ctrl+Tab does navigate to the next tab

[joshua4]

If you are in edit mode (and have the “tool tip” open giving you suggestions for completion), then it seems it should be:

1. Ctrl+Tab to select among choices
2. Enter to select the [bracketed] choice, or to select the only suggestion given

These do work with a German kezboard for me under Windows 10 with LO 7.5. If I am in the edit mode with the tool tip showing, I do not get the behavior of the navigation when pressing Ctrl+Tab.

[stueckl]

Looks like Ubuntu does not like the Ctrl+Tab … just which else would it be?
Even tried to remove the keybindings for Ctrl+Tab … still no avail

[joshua4]

Hmmm… On my hp Z210 workstation running Ubuntu 20.04.5 (Focal) and LO 7.3 I’m getting exactly the expected, correct behavior with either the English or the German (no country) keyboard. Ctrl+Tab selects the next auto-suggestion by bracketing it [ ] and then Enter enters it.

Perhaps check your /etc/X11/xorg.conf.d directory for conf files that have an XkbOption set or something??

Version: 7.3.1.3 / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

[stueckl]

Checked the /etc/X11 folder … although I do have the xorg.conf.d directory it is completely empty … so this is – so I would guess – some LO 7.4/7.5 „feature“.
Also checked some gsettings to no avail either.

Looked into LO’s keybindings but couldn’t find anything that’s obviously for that behaviour.

[joshua4]

I’ve seen stranger things caused by the physical keyboard. Have you tried a different keyboard?

The X11 folder was to see if there were any OS/Ubuntu changes to the keyboard. As I understand, it’s for many X11-based systems. Usually there are no files, since usually there are no changes.

I updated my Ubuntu machine to 7.5 and still I do not see any odd behavior. Sorry.