Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Function List

Opens the Function List deck of the Sidebar, which displays all functions that can be inserted into your document. The Function List deck is similar to the Functions tab page of the Function Wizard. The functions are inserted with placeholders to be replaced with your own values.

To access this command...

Choose View - Function List.

The Function List window is a resizable dockable window. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters.

Category List

Lists all the categories to which the different functions are assigned. Select a category to view the appropriate functions in the list field below. Select "All" to view all functions in alphabetical order, irrespective of category. "Last Used" lists the functions you have most recently used.

Function List

Displays the available functions. When you select a function, the area below the list box displays a short description. To insert the selected function double-click it or click the Insert Function into calculation sheet icon.

Insert Function into calculation sheet

Inserts the selected function into the document.