Ask Your Question

How to view a list of available formulas on Calc

asked 2020-04-19 23:14:33 +0100

rafaelhlima gravatar image

updated 2020-04-20 16:54:36 +0100

On LO Calc, when I start typing a formula, for example =SUMPRODUCT, it show the possible formulas as shown below:

image description

If I want to select a different formula among all AutoInput options I need to use the Ctrl + Tab shortcut. The problem is that, in order to reach the desired formula (which in this case is SUMPRODUCT) I need to press this shortcut multiple times.

Is there a way to show a dropdown list of autoinput options in a similar fashion to what MS Excel does?

image description

I know that some people will try to convince me that this is not necessary and that I could simply type =SUMP and my autoinput option would already be =SUMPRODUCT, but I consider the dropdown list approach more useful when I want to explore all possible formulas.

edit retag flag offensive close merge delete


Very interesting! I had asked this question in the German Mail Listing and nobody could answer that the selection works with CTRL + TAB. I was only told to click on Fx.

dscheikey gravatar imagedscheikey ( 2020-04-20 00:34:35 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-19 23:51:09 +0100

flywire gravatar image

updated 2020-04-20 00:19:01 +0100

On Formula Bar, click Function Wizard Icon

image description

edit flag offensive delete link more


This is not what I was looking for, but for the moment it will do the trick. So it means that it is not possible to show available formulas using a dropdown list as in Excel?

rafaelhlima gravatar imagerafaelhlima ( 2020-04-20 00:22:41 +0100 )edit

The other alternative is to just start typing the formula preceded by "=" and the tooltip will list functions which can be scrolled through with Ctrl+Tab as @dscheikey said above until there are no more choices. The interface is different to excel.

flywire gravatar imageflywire ( 2020-04-20 04:53:30 +0100 )edit

... So it means that it is not possible to show available formulas using a dropdown list as in Excel?

yes - that's correct. No function list via dropdown. But you may find View -> Function List useful.

Opaque gravatar imageOpaque ( 2020-04-20 12:43:17 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-19 23:14:33 +0100

Seen: 107 times

Last updated: Apr 20 '20