Ask Your Question
0

Calc function predictive type and autocomplete [closed]

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

Augustin gravatar image

updated 2013-11-13 23:21:04 +0200

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
0

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

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

Stats

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

Seen: 1,518 times

Last updated: Nov 14 '13