Ask Your Question

Calc function predictive type and autocomplete [closed]

asked 2013-11-13 23:19:38 +0100

Augustin gravatar image

updated 2020-07-19 19:46:05 +0100

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 14:49:04.397286

1 Answer

Sort by » oldest newest most voted

answered 2013-11-14 00:43:37 +0100

oweng gravatar image

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():

SEARCH function prediction

Further typing of U now offers =SUBSTITUTE():

SUBSTITUTE function prediction

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-11-13 23:19:38 +0100

Seen: 1,712 times

Last updated: Nov 14 '13