Ask Your Question

Entering formula: Get list of available functions.... [closed]

asked 2014-01-29 08:17:49 +0100

bushtor gravatar image


I have OpenOffice 3 Calc for Mac.

When I in a cell in Excel enter the equal sign and the first character of the function I need, I immediately get a dropdown list of all functions starting with that character, allowing me to select the desired function.

How do I configure Calc to display the same type of available functions starting with the first character entered?

Thanks for help on this.



edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 05:52:45.407645

1 Answer

Sort by » oldest newest most voted

answered 2014-01-29 20:07:30 +0100

hunteke gravatar image

updated 2014-01-29 20:08:51 +0100

Calc does not have this functionality, currently. If you believe this to be a problem (and I might concur with you), I suggest you file an enhancement request. If you do file one, please post a link to it by using the form "fdo#123" (the system will automatically link to the bug report, number 123 in this case).

Meanwhile, a workaround would be to use the "Fx" button to open a dialog box the help you write your formulas. This dialog box contains all functions in list form with a quick synopsis and appropriate input fields for each. It's not what you desire, but it's better than nothing, I suppose.

Calc Fx Button

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-29 08:17:49 +0100

Seen: 102 times

Last updated: Jan 29 '14