<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Sort Lists</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="sortierlisten"></a>
<a name="bm_id3148538"></a>
<a name="bm_id3148538"></a>
<h1 itemprop="articleSection" id="hd_id3145382">Sort Lists</h1>
<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>
<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="exopso"></a>Open a spreadsheet document, choose <span id="swlnsysidm644" class="switchinline"><span hidden="true" id="MACidm645" class="MAC"><span class="emph">LibreOffice - Preferences</span></span><span hidden="true" id="defaultidm647"><span class="emph">Tools - Options</span></span></span><span class="emph"> - LibreOffice Calc - Sort Lists</span>.</p></div>
</div>
</div>
<br>
<span id="swlnapplidm18" class="switch">
<span hidden="true" id="CALCidm19" class="CALC"><div class="embedded"><p class="embedded"><a name="calc_series"></a><a target="_top" href="en-US/text/scalc/guide/calc_series.html">Automatically Filling in Data Based on Adjacent Cells</a>
</p></div>
</span>
</span>
<span id="swlnapplidm21" class="switch">
<span hidden="true" id="CALCidm22" class="CALC"><div class="embedded"><p class="embedded"><a name="sorted_list"></a><a target="_top" href="en-US/text/scalc/guide/sorted_list.html">Applying Sort Lists</a>
</p></div>
</span>
</span>
<a name="bm_id3147336"></a>
<h2 itemprop="articleSection" id="hd_id3149416">Lists</h2>
<p id="par_id3150503" class="paragraph"><span class="avis">Displays all the available lists. These lists can be selected for editing.</span></p>
<a name="bm_id3154758"></a>
<h2 itemprop="articleSection" id="hd_id3147531">Entries</h2>
<p id="par_id3149669" class="paragraph"><span class="avis">Displays the content of the currently selected list. This content can be edited.</span></p>
<a name="bm_id3152811"></a>
<h2 itemprop="articleSection" id="hd_id3145069">Copy list from</h2>
<p id="par_id3149457" class="paragraph"><span class="avis">Defines the spreadsheet and the cells to copy, in order to include them in the <span class="emph">Lists</span> box. The currently selected range in the spreadsheet is the default.</span></p>
<a name="bm_id3145606"></a>
<h2 itemprop="articleSection" id="hd_id3151211">Copy</h2>
<p id="par_id3158409" class="paragraph"><span class="avis">Copies the contents of the cells in the <span class="emph">Copy list from</span> box. If you select a reference to related rows and columns, the <a target="_top" href="en-US/text/shared/optionen/01060401.html"><span class="emph">Copy List</span></a> dialog appears after clicking the button. You can use this dialog to define if the reference is converted to sort lists by row or by column.</span></p>
<a name="bm_id3147084"></a>
<a name="bm_id3147085"></a>
<h2 itemprop="articleSection" id="hd_id3154684">New/Discard</h2>
<p id="par_id3153970" class="paragraph"><span class="avis">Enters the contents of a new list into the <span class="emph">Entries</span> box.</span> This button will change from <span class="emph">New</span> to <span class="emph">Discard</span>, which enables you to delete the new list.</p>
<a name="bm_id3149563"></a>
<a name="bm_id3149562"></a>
<h2 itemprop="articleSection" id="hd_id3144760">Add/Modify</h2>
<p id="par_id3145785" class="paragraph"><span class="avis">Adds a new list into the <span class="emph">Lists</span> box.</span> If you would like to edit this list in the <span class="emph">Entries</span> box, this button will change from <span class="emph">Add</span> to <span class="emph">Modify</span>, which enables you to include the newly modified list.</p>
<div class="embedded">
<a name="loeschen"></a>
<h3 id="hd_id3149180">Delete</h3>
<p id="par_id3153750" class="paragraph"><span class="avis">Deletes the selected element or elements after confirmation.</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/01060400.xhp" target="_blank">/text/shared/optionen/01060400.xhp</a></p>
<p>Title is: Sort Lists</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 |
|