<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Spreadsheet Options</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">
<a name="bm_id4992961"></a>
<a name="bm_id5861691"></a>
<h1 itemprop="articleSection" id="hd_id3156414">LibreOffice Calc Options</h1>
<p id="par_id3145345" class="paragraph"><a name="allgemein"></a><span class="avis">Defines various settings for spreadsheets, contents to be displayed, and the cursor direction after a cell entry. You can also define sorting lists, determine the number of decimal places and the settings for recording and highlighting changes. </span>
</p>
<a name="howtoget"></a><div class="howtoget">
<div><p class="howtogetheader"><a name="wie"></a>To access this command...
</p></div>
<div class="howtogetbody">
<div class="embedded"><p class="embedded"><a name="tabellendokument"></a>Open a spreadsheet document, choose <span id="swlnsysidm604" class="switchinline"><span hidden="true" id="MACidm605" class="MAC"><span class="emph">LibreOffice - Preferences</span></span><span hidden="true" id="defaultidm607"><span class="emph">Tools - Options</span></span></span><span class="emph"> - LibreOffice Calc</span>.</p></div>
</div>
</div>
<br>
<div class="embedded">
<a name="eingabe"></a>
<h2 itemprop="articleSection" id="hd_id3153311"><a target="_top" href="en-US/text/shared/optionen/01060300.html">General</a></h2>
<p id="par_id3156410" class="paragraph">Defines general settings for spreadsheet documents.</p>
</div>
<div class="embedded">
<a name="defaults"></a>
<h2 itemprop="articleSection" id="hd_id3145071"><a target="_top" href="en-US/text/shared/optionen/01061000.html">Defaults</a></h2>
<p id="par_id3147576" class="paragraph"><span class="avis">Defines default settings for new spreadsheet documents.</span></p>
</div>
<div class="embedded">
<a name="inhalte"></a>
<h2 itemprop="articleSection" id="hd_id3150445"><a target="_top" href="en-US/text/shared/optionen/01060100.html">View</a></h2>
<p id="par_id3153988" class="paragraph"><span class="avis">Defines which elements of the <span class="productname">LibreOffice</span> Calc main window are displayed. You can also show or hide highlighting of values in tables.</span></p>
</div>
<div class="embedded">
<a name="berechnen"></a>
<h2 id="hd_id3145071"><a target="_top" href="en-US/text/shared/optionen/01060500.html">Calculate</a></h2>
<p id="par_id3147576" class="paragraph"><span class="avis">Defines the calculation settings for spreadsheets.</span> Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.</p>
</div>
<div class="embedded">
<a name="formula"></a>
<h2 itemprop="articleSection" id="hd_id3145071"><a target="_top" href="en-US/text/shared/optionen/01060900.html">Formula</a></h2>
<p id="par_id3147576" class="paragraph"><span class="avis">Defines formula syntax options and loading options for LibreOffice Calc.</span></p>
</div>
<div class="embedded">
<a name="sortierlisten"></a>
<h2 itemprop="articleSection" id="hd_id3145382"><a target="_top" href="en-US/text/shared/optionen/01060400.html">Sort Lists</a></h2>
<p id="par_id3153825" class="paragraph"><span class="avis">All user-defined lists are displayed in the<span class="emph"> Sort Lists </span>dialog. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.</span></p>
</div>
<div class="embedded">
<a name="aenderungen"></a>
<h2 itemprop="articleSection" id="hd_id3159399"><a target="_top" href="en-US/text/shared/optionen/01060600.html">Changes</a></h2>
<p id="par_id3155390" class="paragraph"><span class="avis">The<span class="emph"> Changes </span>dialog specifies various options for highlighting recorded changes in documents.</span></p>
</div>
<div class="embedded">
<a name="compatibility"></a>
<h2 itemprop="articleSection" id="hd_id3145071"><a target="_top" href="en-US/text/shared/optionen/01060800.html">Compatibility</a></h2>
<p id="par_id3147576" class="paragraph"><span class="avis">Defines compatibility options for LibreOffice Calc.</span></p>
</div>
<div class="embedded">
<a name="raster"></a>
<h2 itemprop="articleSection" id="hd_id3147226"><a target="_top" href="en-US/text/shared/optionen/01050100.html">Grid</a></h2>
<p id="par_id3147088" class="paragraph"><span class="avis">Specifies the settings for the configurable grid on your document pages. This grid helps you determine the exact position of your objects. You can also set this grid in line with the "magnetic" snap grid.</span></p>
</div>
<div class="embedded">
<a name="drucken"></a>
<h2 itemprop="articleSection" id="hd_id3153311"><a target="_top" href="en-US/text/shared/optionen/01060700.html">Print</a></h2>
<p id="par_id3143267" class="paragraph"><span class="avis">Determines the printer settings for spreadsheets.</span></p>
</div>
<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>
</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/optionen/01060000.xhp" target="_blank">/text/shared/optionen/01060000.xhp</a></p>
<p>Title is: Spreadsheet Options</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| 01000000.html | File | 10.06 KB | 0644 |
|
| 01010000.html | File | 8.36 KB | 0644 |
|
| 01010100.html | File | 9.48 KB | 0644 |
|
| 01010200.html | File | 15.93 KB | 0644 |
|
| 01010300.html | File | 10.29 KB | 0644 |
|
| 01010301.html | File | 4.29 KB | 0644 |
|
| 01010400.html | File | 16.41 KB | 0644 |
|
| 01010401.html | File | 5.94 KB | 0644 |
|
| 01010501.html | File | 10 KB | 0644 |
|
| 01010600.html | File | 6.11 KB | 0644 |
|
| 01010700.html | File | 9.65 KB | 0644 |
|
| 01010800.html | File | 11.59 KB | 0644 |
|
| 01010900.html | File | 8.81 KB | 0644 |
|
| 01012000.html | File | 6.21 KB | 0644 |
|
| 01013000.html | File | 7.26 KB | 0644 |
|
| 01020000.html | File | 5.36 KB | 0644 |
|
| 01020100.html | File | 7.39 KB | 0644 |
|
| 01020300.html | File | 3.27 KB | 0644 |
|
| 01030000.html | File | 4.22 KB | 0644 |
|
| 01030300.html | File | 7.83 KB | 0644 |
|
| 01030500.html | File | 8.73 KB | 0644 |
|
| 01040000.html | File | 8.44 KB | 0644 |
|
| 01040200.html | File | 9.71 KB | 0644 |
|
| 01040300.html | File | 7.47 KB | 0644 |
|
| 01040301.html | File | 5.72 KB | 0644 |
|
| 01040400.html | File | 11.22 KB | 0644 |
|
| 01040500.html | File | 10.69 KB | 0644 |
|
| 01040600.html | File | 11.31 KB | 0644 |
|
| 01040700.html | File | 6.24 KB | 0644 |
|
| 01040900.html | File | 11.83 KB | 0644 |
|
| 01041000.html | File | 13.02 KB | 0644 |
|
| 01041100.html | File | 6.69 KB | 0644 |
|
| 01050000.html | File | 5.79 KB | 0644 |
|
| 01050100.html | File | 9.07 KB | 0644 |
|
| 01050300.html | File | 3.53 KB | 0644 |
|
| 01060000.html | File | 7.58 KB | 0644 |
|
| 01060100.html | File | 13.7 KB | 0644 |
|
| 01060300.html | File | 11.52 KB | 0644 |
|
| 01060400.html | File | 6.47 KB | 0644 |
|
| 01060401.html | File | 4.14 KB | 0644 |
|
| 01060500.html | File | 19.05 KB | 0644 |
|
| 01060600.html | File | 4.63 KB | 0644 |
|
| 01060700.html | File | 5.05 KB | 0644 |
|
| 01060800.html | File | 6.93 KB | 0644 |
|
| 01060900.html | File | 11.13 KB | 0644 |
|
| 01061000.html | File | 3.95 KB | 0644 |
|
| 01070000.html | File | 4.98 KB | 0644 |
|
| 01070100.html | File | 5.72 KB | 0644 |
|
| 01070300.html | File | 12.13 KB | 0644 |
|
| 01070400.html | File | 8.21 KB | 0644 |
|
| 01070500.html | File | 11.01 KB | 0644 |
|
| 01080000.html | File | 4.97 KB | 0644 |
|
| 01090000.html | File | 4.44 KB | 0644 |
|
| 01090100.html | File | 6.8 KB | 0644 |
|
| 01110000.html | File | 3.78 KB | 0644 |
|
| 01110100.html | File | 4.85 KB | 0644 |
|
| 01130100.html | File | 13.82 KB | 0644 |
|
| 01130200.html | File | 5.55 KB | 0644 |
|
| 01140000.html | File | 12.07 KB | 0644 |
|
| 01150000.html | File | 6.67 KB | 0644 |
|
| 01150100.html | File | 7.5 KB | 0644 |
|
| 01150200.html | File | 4.75 KB | 0644 |
|
| 01150300.html | File | 6.48 KB | 0644 |
|
| 01160000.html | File | 4.2 KB | 0644 |
|
| 01160100.html | File | 4.91 KB | 0644 |
|
| 01160200.html | File | 4.4 KB | 0644 |
|
| 01160201.html | File | 3.51 KB | 0644 |
|
| BasicIDE.html | File | 11.53 KB | 0644 |
|
| detailedcalculation.html | File | 8.92 KB | 0644 |
|
| experimental.html | File | 3.26 KB | 0644 |
|
| expertconfig.html | File | 6.78 KB | 0644 |
|
| java.html | File | 6.88 KB | 0644 |
|
| javaclasspath.html | File | 4.59 KB | 0644 |
|
| javaparameters.html | File | 5.52 KB | 0644 |
|
| macrosecurity.html | File | 3.88 KB | 0644 |
|
| macrosecurity_sl.html | File | 5.17 KB | 0644 |
|
| macrosecurity_ts.html | File | 4.14 KB | 0644 |
|
| mailmerge.html | File | 5.7 KB | 0644 |
|
| online_update.html | File | 6.65 KB | 0644 |
|
| opencl.html | File | 4.77 KB | 0644 |
|
| securityoptionsdialog.html | File | 6.55 KB | 0644 |
|
| serverauthentication.html | File | 5.34 KB | 0644 |
|
| testaccount.html | File | 3.78 KB | 0644 |
|
| viewcertificate.html | File | 3.49 KB | 0644 |
|
| viewcertificate_c.html | File | 2.99 KB | 0644 |
|
| viewcertificate_d.html | File | 3.08 KB | 0644 |
|
| viewcertificate_g.html | File | 2.89 KB | 0644 |
|