Frequently-Used Buttons


Clicking Cancel closes a dialog without saving any changes made.


Applies all changes and closes the wizard.


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 numerical 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 numerical 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".


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

Kontekstinis meniu

Jei norite atverti objekto kontekstinį meniu, pirmiausia pažymėkite objektą spustelėdami jį pelės klavišu, tada . Kai kuriuos kontekstinius meniu galima atverti ir nepažymėjus objekto. „LibreOffice“ programoje kontekstinius meniu turi kone kiekvienas objektas.


Deletes the selected element or elements after confirmation.

Å alinti

Pažymėti įrašai pašalinami nereikalaujant patvirtinimo.


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 1cm, 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.


Closes the dialog and saves all changes.


Closes the dialog.


Applies the modified or selected values without closing the dialog.

Shrink / Maximize

Click the Shrink icon to reduce the dialog 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 Maximize icon. Click it to restore the dialog to its original size.

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





Peržiūros laukas

Rodoma nustatyto formato peržiūra.


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

Dialogo lango mygtukai


Pakeistos reikšmės kortelėje atstatomos į ankstesniąsias.


Panaikinami visi pakeitimai ir užveriamas dialogo langas.


Įrašomi visi pakeitimai ir užveriamas dialogo langas.


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


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


Resets modified values back to the default values.

Warning Icon

A confirmation query does not appear. If you confirm the dialog with OK all settings in this dialog are reset.


Dialogo lange rodomos reikšmės atstatomos į numatytąsias diegimo reikšmes.

Warning Icon

Atstatant numatytąsias nuostatas patvirtinimo neprašoma.


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


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

See also the following functions:

The search supports regular expressions. 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 precede every character with a \ character. You can switch the automatic evaluation of regular expression on and off in - LibreOffice Calc - Calculate.

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 dialog buttons


Save the changes in the page and close the Options dialog.


Close the Options dialog and discard all changes done.


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

Warning Icon

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