Calc function predictive type and autocomplete

[Augustin]

Hi.
When I use Ms excel and type a new formula into a cell, the editor has a predictive algorithm that shows the formula that it thinks I might be trying to use. If this formula is indeed the one I’m searching for, then I just hit tab
and the formula automatically completes.

Is there an option in LibreOffice Calc that could provide a similar behavior?

Thank you.

[oweng]

If you are talking about selecting from the reference list of functions, rather than formulas already entered, then Calc uses the ENTER key rather than TAB for selection / completion. If I type =S I am offered =SEARCH():

Further typing of U now offers =SUBSTITUTE():