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

Frequently-Used Buttons

Cancel

Clicking Cancel closes a dialogue box without saving any changes made.

Finish

Applies all changes and closes the wizard.

Toolbars

By clicking the arrow next to some icons you open a toolbar. To move a toolbar, drag the title bar. As soon as you release the mouse button, the toolbar remains at the new position. Drag the title bar to another position, or drag to an edge of the window, where the toolbar will dock. Close a toolbar by clicking the Close Window icon. Make the toolbar visible again by choosing View - Toolbars - (toolbar name).

Spin button

  1. In form controls, a spin button is a property of a numeric field, currency field, date field or time field. If the property "Spin button" is enabled, the field shows a pair of symbols with arrows pointing to opposing directions, either vertically or horizontally.

  2. In the Basic IDE, a spin button is the name used for the numerical field together with the two arrow symbols.

You can type a numeric value into the field next to the spin button, or select the value with the Up Arrow or Down Arrow symbols on the spin button. On the keyboard you can press the Up Arrow and Down Arrow keys to increase or reduce the value. You can press the Page Up and Page Down keys to set the maximum and minimum value.

If the field next to the spin button defines numerical values, you can also define a measurement unit, for example, 1 cm or 5 mm, 12 pt or 2".

Convert

If you click forwards through the dialogue box, this button is called Next. On the last page the button has the name Convert. The conversion is then performed by clicking the button.

Context Menu

To activate the context menu of an object, first click the object with the left mouse button to select it, and then, click the right mouse button. Some context menus can be called even if the object has not been selected. Context menus are found just about everywhere in Office.

Delete

Deletes the selected element or elements after confirmation.

Delete

Deletes the selected element or elements without requiring confirmation.

Metrics

You can enter values in the input fields in different units of measurement. The default unit is inches. However, if you want a space of exactly 1 cm, then type "1cm". Additional units are available according to the context, for example, 12 pt for a 12 point spacing. If the value of the new unit is unrealistic, the program uses a predefined maximum or minimum value.

Close

Closes the dialogue box and saves all changes.

Close

Closes the dialogue box.

Apply

Applies the modified or selected values without closing the dialogue box.

This option appears only for Paragraph Style, Frame Style, and Page Style.

This option appears only for Paragraph Style and Character Style.

Shrink / Expand

Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Expand icon. Click it to restore the dialogue box to its original size.

The dialogue box is automatically minimised when you click within a sheet with the mouse. As soon as you release the mouse button, the dialogue box is restored and the reference range defined with the mouse is highlighted in the document by a blue frame.

Shrink

Expand

Preview Field

Displays a preview of the current selection.

Preview

Displays a preview of the current selection.

Next

Click the Next button, and the wizard uses the current dialogue box settings and proceeds to the next step. If you are on the last step, this button becomes Create.

Dialog Buttons

Reset

Resets modified values back to the tab page previous values.

Cancel

Closes dialogue box and discards all changes.

OK

Saves all changes and closes dialogue box.

Reset

Resets changes made to the current tab to those applicable when this dialogue box was opened.

Reset

Resets changes made to the current tab to those applicable when this dialogue box was opened. A confirmation query does not appear when you close the dialogue box.

Standard

Resets the values visible in the dialogue box back to the default installation values.

A confirmation does not appear before the defaults are reloaded.

Cancel

Closes dialogue box and discards changes on all tabs. If Apply was used, then changes after the last use of Apply are discarded.

Reset

Resets modified values on the current tab back to the values when the dialogue box was opened. If Apply is used before closing the dialogue box, then values are reset to those after the last use of Apply.

Apply

Applies modifications on all tabs without closing dialogue box. Cannot be reverted with Reset.

Reset to Parent

Values for the current tab are set to those found in the corresponding tab of the style specified in “Inherit from” in Organiser. In all cases, also when “Inherit from” is “- None -”, current tab values specified in “Contains” are removed.

This option appears only for Paragraph Style, Character Style, and Frame Style.

Back

View the selections in the dialogue box made in the previous step. The current settings remain unchanged. This button can only be activated from page two on.

Options

Click the Options label to expand the dialogue box to show further options. Click again to restore the dialogue box.

See also the following functions:

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in Tools - Options - Office Calc - Calculate.

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".

If an error occurs, the function returns a logical or numerical value.

(This command is only accessible through the context menu).

By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task.

Press Shift+F1 and point to a control to learn more about that control.

Options dialogue box buttons

OK

Save the changes in the page and close the Options dialogue box.

Cancel

Close the Options dialogue box and discard all changes done.

Apply

Applies the modified or selected values without closing the Options dialogue box.

Reset

Resets changes made to the current tab to those applicable when this dialogue box was opened.

Some options cannot be reset once edited. Either edit back the changes manually or click Cancel and reopen the Options dialogue box.