Bug 154994 - Functions sidebar should be searchable as soon as it is focused
Summary: Functions sidebar should be searchable as soon as it is focused
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on: 122718
Blocks: Sidebar-Functions
  Show dependency treegraph
Reported: 2023-04-24 22:26 UTC by Rafael Lima
Modified: 2023-09-19 22:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Rafael Lima 2023-04-24 22:26:24 UTC
The Functions sidebar (Ctrl + Alt + 5) should be searchable, i.e. when it is opened, a textbox should allow filtering the available functions.

This way, the following workflow would be available:
1) Ctrl + Alt + 5 to show the sidebar; the search textbox receives focus and is ready to receive text
2) The user types the parts of the formula to search what they want (search should consider the entire function name)
3) Arrow keys up/down can be used to select the formula
4) Enter will add the formula to the selected cell

Note that currently, as soon as the Functions sidebar is shown, it is neither possible to (i) type letters to move to a function or (ii) use the up/down arrow keys to navigate the list of available functions.
Comment 1 Rafael Lima 2023-04-24 22:29:45 UTC
BTW the search would work similarly to how the Function Wizard works (Insert - Function).
Comment 2 Stéphane Guillou (stragu) 2023-04-25 07:58:20 UTC
I refocused the summary so this does not sound like an exact duplicate of bug 122718, which it now depends on.

I think the workflow you describe does make sense, and wouldn't be inconsistent with other decks: the Gallery and Navigator decks can get text input as soon as they are focused.

Even if bug 122718 is not implemented yet, the focus could be moved to the function list instead of the Insert Function button, as an interim solution.
Comment 3 Stéphane Guillou (stragu) 2023-09-19 22:26:22 UTC
With your implementation in bug 122718, you workflow works exactly as described. Please go ahead and close this one as fixed too! :)