Skip to main content
Skip table of contents

Icons on the toolbar of the formula editor window

You can use the icons (buttons) below the menu to quickly call up the most important formula editor functions.

CommandIconDescription

Save

Key combination <CTRL>+<S>.

Saves the entered formula and closes the formula editor.

To save the current status without closing the formula editor, you can use the key combination <CTRL>+<W>.

Create new macro

A new formula editor window opens in macro mode; you can create the new macro here.

Open macro under cursor

You can use this function to open a macro used in the formula text in a new formula editor window. To do this, place the cursor on the macro (not on the declaration in the brackets) and click on the "Open macro under cursor" icon.

Delete macro

Deletes the currently open macro from the database. You can only delete macros that you have created yourself.

Cut
Copy
Paste



Cut - Copy - Paste selected text parts of the formulas.

To copy a complete formula (i.e. the formula text together with the information on the variables and libraries), use the EDIT, COPY FORMULA command in the main menu of the formula editor.

Undo

Undoes the last action (multi-level).

Restore

Restores the last undone action (multi-level).

Show error

If this icon is activated, errors in the formula text are highlighted in yellow.

Type help for function under cursor

Displays the result object type of the formula on which the cursor is currently positioned in a small window.

Function assistant

Opens the function wizard.

More on this in the chapter The function assistant.

Help for function under Open cursor
<F2>

If the cursor is positioned on a function name in the formula editor, this icon or the <F2> key opens a help page in the Help Center which contains a description of the function.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.