1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <helpdocument version=
"1.0">
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: 01060400.xhp,v $
14 * $Revision: 1.6.4.1 $
16 * This file is part of OpenOffice.org.
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
33 ************************************************************************
38 <topic id=
"textsharedoptionen01060400xml" indexer=
"include">
39 <title id=
"tit" xml-lang=
"en-US">Sort Lists
</title>
40 <filename>/text/shared/optionen/
01060400.xhp
</filename>
44 <section id=
"sortierlisten">
45 <bookmark xml-lang=
"en-US" branch=
"hid/HID_SCPAGE_USERLISTS" id=
"bm_id3148538" localize=
"false"/>
46 <paragraph role=
"heading" id=
"hd_id3145382" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1"><link href=
"text/shared/optionen/01060400.xhp" name=
"Sort Lists">Sort Lists
</link></paragraph>
47 <paragraph role=
"paragraph" id=
"par_id3153825" xml-lang=
"en-US" l10n=
"CHG" oldref=
"2"><ahelp hid=
"HID_SCPAGE_USERLISTS">All user-defined lists are displayed in the
<emph> Sort Lists
</emph>dialog. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.
</ahelp><comment>UFI: fix to #
111848#
</comment></paragraph>
49 <section id=
"howtoget">
50 <embed href=
"text/shared/00/00000406.xhp#exopso"/>
52 <switch select=
"appl">
53 <case select=
"CALC"><embed href=
"text/scalc/guide/calc_series.xhp#calc_series"/>
56 <switch select=
"appl">
57 <case select=
"CALC"><embed href=
"text/scalc/guide/sorted_list.xhp#sorted_list"/>
60 <bookmark xml-lang=
"en-US" branch=
"hid/SC:LISTBOX:RID_SCPAGE_USERLISTS:LB_LISTS" id=
"bm_id3147336" localize=
"false"/>
61 <paragraph role=
"heading" id=
"hd_id3149416" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">Lists
</paragraph>
62 <paragraph role=
"paragraph" id=
"par_id3150503" xml-lang=
"en-US" l10n=
"U" oldref=
"4"><ahelp hid=
"SC:LISTBOX:RID_SCPAGE_USERLISTS:LB_LISTS">Displays all the available lists. These lists can be selected for editing.
</ahelp></paragraph>
63 <bookmark xml-lang=
"en-US" branch=
"hid/SC:MULTILINEEDIT:RID_SCPAGE_USERLISTS:ED_ENTRIES" id=
"bm_id3154758" localize=
"false"/>
64 <paragraph role=
"heading" id=
"hd_id3147531" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5">Entries
</paragraph>
65 <paragraph role=
"paragraph" id=
"par_id3149669" xml-lang=
"en-US" l10n=
"U" oldref=
"6"><ahelp hid=
"SC:MULTILINEEDIT:RID_SCPAGE_USERLISTS:ED_ENTRIES">Displays the content of the currently selected list. This content can be edited.
</ahelp></paragraph>
66 <bookmark xml-lang=
"en-US" branch=
"hid/SC:EDIT:RID_SCPAGE_USERLISTS:ED_COPYFROM" id=
"bm_id3152811" localize=
"false"/>
67 <paragraph role=
"heading" id=
"hd_id3145069" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"7">Copy list from
</paragraph>
68 <paragraph role=
"paragraph" id=
"par_id3149457" xml-lang=
"en-US" l10n=
"U" oldref=
"8"><ahelp hid=
"SC:EDIT:RID_SCPAGE_USERLISTS:ED_COPYFROM">Defines the spreadsheet and the cells to copy, in order to include them in the
<emph>Lists
</emph> box. The currently selected range in the spreadsheet is the default.
</ahelp></paragraph>
69 <bookmark xml-lang=
"en-US" branch=
"hid/SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_COPY" id=
"bm_id3145606" localize=
"false"/>
70 <paragraph role=
"heading" id=
"hd_id3151211" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"13">Copy
</paragraph>
71 <paragraph role=
"paragraph" id=
"par_id3158409" xml-lang=
"en-US" l10n=
"U" oldref=
"14"><ahelp hid=
"SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_COPY">Copies the contents of the cells in the
<emph>Copy list from
</emph> box. If you select a reference to related rows and columns, the
<link href=
"text/shared/optionen/01060401.xhp" name=
"Copy List"><emph>Copy List
</emph></link> 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.
</ahelp></paragraph>
72 <bookmark xml-lang=
"en-US" branch=
"hid/SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_NEW" id=
"bm_id3147084" localize=
"false"/>
73 <paragraph role=
"heading" id=
"hd_id3154684" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"9">New/Discard
</paragraph>
74 <paragraph role=
"paragraph" id=
"par_id3153970" xml-lang=
"en-US" l10n=
"U" oldref=
"10"><ahelp hid=
"SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_NEW">Enters the contents of a new list into the
<emph>Entries
</emph> box.
</ahelp> This button will change from
<emph>New
</emph> to
<emph>Discard
</emph>, which enables you to delete the new list.
</paragraph>
75 <bookmark xml-lang=
"en-US" branch=
"hid/SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_ADD" id=
"bm_id3149562" localize=
"false"/>
76 <paragraph role=
"heading" id=
"hd_id3144760" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"11">Add/Modify
</paragraph>
77 <paragraph role=
"paragraph" id=
"par_id3145785" xml-lang=
"en-US" l10n=
"U" oldref=
"12"><ahelp hid=
"SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_ADD">Adds a new list into the
<emph>Lists
</emph> box.
</ahelp> If you would like to edit this list in the
<emph>Entries
</emph> box, this button will change from
<emph>Add
</emph> to
<emph>Modify
</emph>, which enables you to include the newly modified list.
</paragraph>
78 <embed href=
"text/shared/00/00000001.xhp#loeschen"/>