<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Frequently-Used Buttons</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in all modules"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<h1 id="hd_id3152952">Frequently-Used Buttons</h1>
<a name="abbrechen"></a>
<a name="bm_id4245124"></a>
<a name="bm_id7074800"></a>
<a name="bm_id3147653"></a>
<a name="bm_id833765"></a>
<a name="bm_id7899105"></a>
<a name="bm_id3149183"></a>
<a name="bm_id3149177"></a>
<a name="bm_id3154142"></a>
<a name="bm_id3145416"></a>
<h2 id="hd_id3147617">Cancel</h2>
<p id="par_id3155913" class="paragraph"><span class="avis">Clicking <span class="emph">Cancel</span> closes a dialog without saving any changes made.</span></p>
<a name="finish"></a>
<a name="bm_id3211157"></a>
<a name="bm_id189519"></a>
<h2 id="hd_id2341685">Finish</h2>
<p id="par_id6909390" class="paragraph"><span class="avis">Applies all changes and closes the wizard.</span></p>
<a name="abreissleiste"></a>
<h2 id="hd_id3147477">Toolbars</h2>
<p id="par_id3149783" class="paragraph">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 <span class="emph">Close Window</span> icon. Make the toolbar visible again by choosing <span class="emph">View - Toolbars - (toolbar name)</span>.</p>
<a name="drehfeld"></a>
<h2 id="hd_id3152414">Spin button</h2>
<a name="spinbutton"></a>
<ol>
<li>
<p id="par_id1094088" class="paragraph">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.</p>
</li>
<li>
<p id="par_id7493209" class="paragraph">In the <span class="emph">Basic IDE</span>, a spin button is the name used for the numerical field together with the two arrow symbols.</p>
</li>
</ol>
<p id="par_id3155599" class="paragraph">You can type a numerical value into the field next to the spin button, or select the value with the <span class="emph">Up Arrow</span> or <span class="emph">Down Arrow</span> symbols on the spin button. On the keyboard you can press the <span class="keycode">Up Arrow</span> and <span class="keycode">Down Arrow</span> keys to increase or reduce the value. You can press the <span class="keycode">Page Up</span> and <span class="keycode">Page Down</span> keys to set the maximum and minimum value.</p>
<p id="par_id3150264" class="paragraph">If the field next to the spin button defines numerical values, you can also define a <a target="_top" href="en-US/text/shared/00/00000003.html#metrik">measurement unit</a>, for example, <span class="emph">1 cm or 5 mm, 12 pt or 2"</span>.</p>
<a name="import"></a>
<h2 id="hd_id3154232">Convert</h2>
<p id="par_id3148983" class="paragraph"><span class="avis">If you click forward through the dialog, this button is called <span class="emph">Next</span>. On the last page the button has the name <span class="emph">Convert</span>. The conversion is then performed by clicking the button.</span></p>
<a name="kontextmenue"></a>
<h2 id="hd_id3145129">Context Menu</h2>
<a name="contextmenu"></a>
<p id="par_id3156553" class="paragraph"><a name="context"></a>To activate the context menu of an object, first click the object with the <span id="swlnsysidm63" class="switchinline"><span hidden="true" id="MACidm64" class="MAC">
</span><span hidden="true" id="defaultidm65">left</span></span> mouse button to select it, and then, <span id="swlnsysidm66" class="switchinline"><span hidden="true" id="MACidm67" class="MAC">while holding down the <span class="emph">Ctrl</span> key or the <span class="emph">Command</span> and <span class="emph">Option</span> keys, click the mouse button again
</span><span hidden="true" id="defaultidm71"> click the right mouse button</span></span>. Some context menus can be called even if the object has not been selected. Context menus are found just about everywhere in LibreOffice.</p>
<a name="loeschen"></a>
<a name="bm_id3153766"></a>
<a name="bm_id3153839"></a>
<a name="bm_id3150089"></a>
<a name="bm_id3146120"></a>
<a name="bm_id3148722"></a>
<a name="bm_id3152577"></a>
<a name="bm_id3156382"></a>
<a name="bm_id3148943"></a>
<a name="bm_id3149762"></a>
<a name="bm_id3148924"></a>
<a name="bm_id3153717"></a>
<a name="bm_id3156007"></a>
<a name="bm_id3143232"></a>
<a name="bm_id3214514"></a>
<a name="bm_id3145749"></a>
<a name="bm_id3150443"></a>
<h2 id="hd_id3149180">Delete</h2>
<p id="par_id3153750" class="paragraph"><span class="avis">Deletes the selected element or elements after confirmation.</span></p>
<a name="loeschen1"></a>
<a name="bm_id3146916"></a>
<a name="bm_id3147296"></a>
<a name="bm_id6168401"></a>
<a name="bm_id3154687"></a>
<a name="bm_id3154686"></a>
<a name="bm_id7878353"></a>
<a name="bm_id5413373"></a>
<a name="bm_id2580950"></a>
<h2 id="hd_id3147557">Delete</h2>
<p id="par_id3155338" class="paragraph"><span class="avis">Deletes the selected element or elements without requiring confirmation.</span></p>
<a name="metrik"></a>
<h2 id="hd_id3148620">Metrics</h2>
<p id="par_id3145345" class="paragraph">You can enter values in the input fields in different <a target="_top" href="en-US/text/shared/00/00000003.html#metrik">units of measurement</a>. 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.</p>
<a name="schliessen"></a>
<h2 id="hd_id3155535">Close</h2>
<p id="par_id3147008" class="paragraph"><span class="avis">Closes the dialog and saves all changes.</span></p>
<a name="schliessen2"></a>
<h2 id="hd_id3147275">Close</h2>
<p id="par_id3153031" class="paragraph"><span class="avis">Closes the dialog.</span></p>
<a name="uebernehmen"></a>
<a name="bm_id3149053"></a>
<h2 id="hd_id3156113">Apply</h2>
<p id="par_id3155341" class="paragraph"><span class="avis">Applies the modified or selected values without closing the dialog.</span></p>
<a name="eingabesymbol"></a>
<a name="bm_id3155067"></a>
<a name="bm_id3149785"></a>
<a name="bm_id3149019"></a>
<a name="bm_id3153712"></a>
<a name="bm_id3153364"></a>
<a name="bm_id3153363"></a>
<a name="bm_id3149400"></a>
<a name="bm_id3155962"></a>
<a name="bm_id3145640"></a>
<a name="bm_id3153713"></a>
<a name="bm_id3152596"></a>
<a name="bm_id3146975"></a>
<a name="bm_id3154321"></a>
<a name="bm_id3155532"></a>
<a name="bm_id3159155"></a>
<a name="bm_id3149262"></a>
<a name="bm_id3153190"></a>
<a name="bm_id3150010"></a>
<a name="bm_id3146985"></a>
<h2 id="hd_id3153760">Shrink / Maximize</h2>
<p id="par_id3153087" class="paragraph"><span class="avis">Click the <span class="emph">Shrink</span> 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 <span class="emph">Maximize</span> icon. Click it to restore the dialog to its original size.</span></p>
<p id="par_id3155062" class="paragraph">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.</p>
<div class="icontable">
<div class="iconcell">
<p id="par_id3157808" class="paragraphintable"><img src="media/icon-themes/formula/res/refinp1.svg" class="iconimage" alt="Icon" title="Icon" style="width:16px;height:16px"></p>
</div>
<div class="iconcell">
<p id="par_id3153321" class="paragraphintable">Shrink</p>
</div>
</div>
<div class="icontable">
<div class="iconcell">
<p id="par_id3153349" class="paragraphintable"><img src="media/icon-themes/formula/res/refinp2.svg" class="iconimage" alt="Icon" title="Icon" style="width:16px;height:16px"></p>
</div>
<div class="iconcell">
<p id="par_id3155628" class="paragraphintable">Maximize</p>
</div>
</div>
<a name="vorschau"></a>
<a name="bm_id3157970"></a>
<a name="bm_id3153896"></a>
<a name="bm_id3155601"></a>
<a name="bm_id3147175"></a>
<a name="bm_id3147227"></a>
<h2 id="hd_id3156192">Preview Field</h2>
<p id="par_id3154046" class="paragraph"><span class="avis">Displays a preview of the current selection.</span></p>
<a name="weiterautopi"></a>
<a name="bm_id8281197"></a>
<a name="bm_id3147576"></a>
<a name="bm_id4154179"></a>
<a name="bm_id1058076"></a>
<a name="bm_id480666"></a>
<a name="bm_id3149095"></a>
<a name="bm_id31475761"></a>
<a name="bm_id3155135"></a>
<h2 id="hd_id3145609">Next</h2>
<p id="par_id3152473" class="paragraph"><span class="avis">Click the <span class="emph">Next</span> 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 <span class="emph">Create</span>.</span></p>
<a name="AutocorrectButtons"></a>
<a name="bm_id4539934"></a>
<h2 id="hd_id3149671">Dialog Buttons</h2>
<h3 id="par_id3145069">Reset</h3>
<p id="par_id3145169" class="paragraph"><span class="avis">Resets modified values back to the tab page previous values.</span></p>
<a name="bm_id4539935"></a>
<h3 id="par_id3145070">Cancel</h3>
<p id="par_id3145269" class="paragraph"><span class="avis">Closes dialog and discards all changes.</span></p>
<a name="bm_id4539936"></a>
<h3 id="par_id3145071">OK</h3>
<p id="par_id3145369" class="paragraph"><span class="avis">Saves all changes and closes dialog.</span></p>
<a name="zurueck"></a>
<a name="bm_id4539933"></a>
<h2 id="hd_id3149670">Reset</h2>
<p id="par_id3145068" class="paragraph"><span class="avis">Resets changes made to the current tab to those applicable when this dialog was opened.</span></p>
<a name="zurueck2"></a>
<a name="bm_id3151054"></a>
<h2 id="hd_id3148755">Reset</h2>
<p id="par_id3149651" class="paragraph"><span class="avis">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.</span></p>
<a name="standard"></a>
<a name="bm_id481887"></a>
<a name="bm_id3157322"></a>
<a name="bm_id3083280"></a>
<h2 id="hd_id3145173">Standard</h2>
<p id="par_id3154153" class="paragraph"><span class="avis">Resets the values visible in the dialog back to the default installation values.</span></p>
<div class="warning">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" title="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id3154299">A confirmation does not appear before the defaults are reloaded.</p></div>
</div>
<br>
<a name="zurueckautopi"></a>
<a name="bm_id1064180"></a>
<a name="bm_id3681447"></a>
<a name="bm_id5176244"></a>
<a name="bm_id1207617"></a>
<a name="bm_id3154318"></a>
<a name="bm_id3145346"></a>
<a name="bm_id3150984"></a>
<a name="bm_id3156155"></a>
<h2 id="hd_id3147502">Back</h2>
<p id="par_id3150439" class="paragraph"><span class="avis">View the selections in the dialog made in the previous step. The current settings remain unchanged.</span> This button can only be activated from page two on.</p>
<a name="zusaetze"></a>
<a name="bm_id3157322"></a>
<h2 id="hd_id3147353">Options</h2>
<p id="par_id3155314" class="paragraph"><span class="avis">Click the <span class="emph">Options</span> label to expand the dialog to show further options. Click again to restore the dialog.</span></p>
<p id="par_id3161659" class="paragraph"><a name="siehe"></a>See also the following functions:</p>
<a name="regulaer"></a>
<p id="par_id3147418" class="paragraph">The search supports wildcards or <a target="_top" href="en-US/text/shared/01/02100001.html">regular expressions</a>. 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 <a target="_top" href="en-US/text/shared/optionen/01060500.html"><span id="swlnsysidm245" class="switchinline"><span hidden="true" id="MACidm246" class="MAC"><span class="menuitem">LibreOffice - Preferences</span></span><span hidden="true" id="defaultidm248"><span class="menuitem">Tools - Options</span></span></span><span class="menuitem"> - LibreOffice Calc - Calculate</span></a>.</p>
<a name="regexnumex"></a>
<div class="warning">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" title="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id651572973288601">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". </p></div>
</div>
<br>
<p id="par_id3163714" class="paragraph"><a name="wahr"></a>If an error occurs, the function returns a logical or numerical value.</p>
<p id="par_id3154145" class="paragraph"><a name="kontext"></a>(This command is only accessible through the <a target="_top" href="en-US/text/shared/00/00000005.html#kontextmenue">context menu</a>).</p>
<p id="par_id3152791" class="paragraph"><a name="wiederholen"></a>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.</p>
<p id="par_id9345377" class="paragraph"><a name="ShiftF1"></a>Press <span class="emph">Shift+F1</span> and point to a control to learn more about that control.</p>
<a name="optionsbuttons"></a>
<h2 id="hd_id631527692833772">Options dialog buttons</h2>
<h3 id="hd_id831527692839432">OK</h3>
<p id="par_id471527692844934" class="paragraph">Save the changes in the page and close the Options dialog.</p>
<h3 id="hd_id261527692850720">Cancel</h3>
<p id="par_id571527692855533" class="paragraph">Close the Options dialog and discard all changes done.</p>
<div class="embedded">
<a name="zurueck"></a>
<h3 id="hd_id3149670">Reset</h3>
<p id="par_id3145068" class="paragraph"><span class="avis">Resets changes made to the current tab to those applicable when this dialog was opened.</span></p>
</div>
<a name="optionsbuttonwarn01"></a>
<div class="warning">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" title="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id261527693436801">Some options cannot be reset once edited. Either edit back the changes manually or click <span class="emph">Cancel</span> and reopen the <span class="emph">Options</span> dialog.</p></div>
</div>
<br>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/shared/00/00000001.xhp" target="_blank">/text/shared/00/00000001.xhp</a></p>
<p>Title is: Frequently-Used Buttons</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>