00000412.xhp (02dbb15c) 00000412.xhp (26ad06e5)
1<?xml version="1.0" encoding="UTF-8"?>
2
1<?xml version="1.0" encoding="UTF-8"?>
2
3
4
5<!--***********************************************************
3<!--***********************************************************
6 *
4 *
7 * Licensed to the Apache Software Foundation (ASF) under one
8 * or more contributor license agreements. See the NOTICE file
9 * distributed with this work for additional information
10 * regarding copyright ownership. The ASF licenses this file
11 * to you under the Apache License, Version 2.0 (the
12 * "License"); you may not use this file except in compliance
13 * with the License. You may obtain a copy of the License at
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements. See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership. The ASF licenses this file
9 * to you under the Apache License, Version 2.0 (the
10 * "License"); you may not use this file except in compliance
11 * with the License. You may obtain a copy of the License at
14 *
12 *
15 * http://www.apache.org/licenses/LICENSE-2.0
13 * http://www.apache.org/licenses/LICENSE-2.0
16 *
14 *
17 * Unless required by applicable law or agreed to in writing,
18 * software distributed under the License is distributed on an
19 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
20 * KIND, either express or implied. See the License for the
21 * specific language governing permissions and limitations
22 * under the License.
15 * Unless required by applicable law or agreed to in writing,
16 * software distributed under the License is distributed on an
17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
18 * KIND, either express or implied. See the License for the
19 * specific language governing permissions and limitations
20 * under the License.
23 *
21 *
24 ***********************************************************-->
25
22 ***********************************************************-->
23
26
27
28
29 <helpdocument version="1.0">
24<helpdocument version="1.0">
30<meta>
31<topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
32<title id="tit" xml-lang="en-US">Data Menu</title>
33<filename>/text/scalc/00/00000412.xhp</filename>
34</topic>
35</meta>
36<body>
37<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Menu</paragraph>

--- 9 unchanged lines hidden (view full) ---

47<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Data - Sort - Sort Criteria</emph> tab</paragraph>
48<paragraph role="paragraph" id="par_id3154516" xml-lang="en-US" l10n="CHG" oldref="7">On Standard bar, click</paragraph>
49<section id="sysortieren">
50<table id="tbl_id3156023">
51<tablerow>
52<tablecell colspan="" rowspan="">
53<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US" l10n="E">
54<image id="img_id3150543" src="res/commandimagelist/sc_sortup.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt>
25<meta>
26<topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
27<title id="tit" xml-lang="en-US">Data Menu</title>
28<filename>/text/scalc/00/00000412.xhp</filename>
29</topic>
30</meta>
31<body>
32<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Menu</paragraph>

--- 9 unchanged lines hidden (view full) ---

42<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Data - Sort - Sort Criteria</emph> tab</paragraph>
43<paragraph role="paragraph" id="par_id3154516" xml-lang="en-US" l10n="CHG" oldref="7">On Standard bar, click</paragraph>
44<section id="sysortieren">
45<table id="tbl_id3156023">
46<tablerow>
47<tablecell colspan="" rowspan="">
48<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US" l10n="E">
49<image id="img_id3150543" src="res/commandimagelist/sc_sortup.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt>
55 </image></paragraph>
50</image></paragraph>
56</tablecell>
57<tablecell colspan="" rowspan="">
58<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="8">Sort Ascending</paragraph>
59</tablecell>
60</tablerow>
61<tablerow>
62<tablecell colspan="" rowspan="">
63<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="E">
64<image id="img_id3125863" src="res/commandimagelist/sc_sortdown.png" width="0.1701inch" height="0.1701inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt>
51</tablecell>
52<tablecell colspan="" rowspan="">
53<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="8">Sort Ascending</paragraph>
54</tablecell>
55</tablerow>
56<tablerow>
57<tablecell colspan="" rowspan="">
58<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="E">
59<image id="img_id3125863" src="res/commandimagelist/sc_sortdown.png" width="0.1701inch" height="0.1701inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt>
65 </image></paragraph>
60</image></paragraph>
66</tablecell>
67<tablecell colspan="" rowspan="">
68<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="9">Sort Descending</paragraph>
69</tablecell>
70</tablerow>
71</table>
72</section>
73</section>

--- 6 unchanged lines hidden (view full) ---

80</paragraph>
81<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="CHG" oldref="13">On Tools bar or Table Data bar, click</paragraph>
82<section id="syautofilter">
83<table id="tbl_id3155418">
84<tablerow>
85<tablecell colspan="" rowspan="">
86<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="E">
87<image id="img_id3149413" src="res/commandimagelist/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt>
61</tablecell>
62<tablecell colspan="" rowspan="">
63<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="9">Sort Descending</paragraph>
64</tablecell>
65</tablerow>
66</table>
67</section>
68</section>

--- 6 unchanged lines hidden (view full) ---

75</paragraph>
76<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="CHG" oldref="13">On Tools bar or Table Data bar, click</paragraph>
77<section id="syautofilter">
78<table id="tbl_id3155418">
79<tablerow>
80<tablecell colspan="" rowspan="">
81<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="E">
82<image id="img_id3149413" src="res/commandimagelist/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt>
88 </image></paragraph>
83</image></paragraph>
89</tablecell>
90<tablecell colspan="" rowspan="">
91<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="14">AutoFilter</paragraph>
92</tablecell>
93</tablerow>
94</table>
95</section>
96</section>

--- 8 unchanged lines hidden (view full) ---

105</paragraph>
106<paragraph role="paragraph" id="par_id3155961" xml-lang="en-US" l10n="CHG" oldref="48">On Table Data bar, click <emph>Remove Filter/Sort</emph>
107</paragraph>
108<table id="tbl_id3146919">
109<tablerow>
110<tablecell colspan="" rowspan="">
111<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="E">
112<image id="img_id3145792" src="res/commandimagelist/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt>
84</tablecell>
85<tablecell colspan="" rowspan="">
86<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="14">AutoFilter</paragraph>
87</tablecell>
88</tablerow>
89</table>
90</section>
91</section>

--- 8 unchanged lines hidden (view full) ---

100</paragraph>
101<paragraph role="paragraph" id="par_id3155961" xml-lang="en-US" l10n="CHG" oldref="48">On Table Data bar, click <emph>Remove Filter/Sort</emph>
102</paragraph>
103<table id="tbl_id3146919">
104<tablerow>
105<tablecell colspan="" rowspan="">
106<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="E">
107<image id="img_id3145792" src="res/commandimagelist/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt>
113 </image></paragraph>
108</image></paragraph>
114</tablecell>
115<tablecell colspan="" rowspan="">
116<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="49">Remove Filter/Sort</paragraph>
117</tablecell>
118</tablerow>
119</table>
120</section>
121<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US" l10n="U" oldref="21"><variable id="dnaftas">Choose <emph>Data - Filter - Hide AutoFilter</emph>

--- 28 unchanged lines hidden (view full) ---

150<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US" l10n="U" oldref="51">F12</paragraph>
151<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US" l10n="CHG" oldref="35">On <emph>Tools</emph> bar, click</paragraph>
152<section id="sygruppieren">
153<table id="tbl_id3154532">
154<tablerow>
155<tablecell colspan="" rowspan="">
156<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="E">
157<image id="img_id3153287" src="res/commandimagelist/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt>
109</tablecell>
110<tablecell colspan="" rowspan="">
111<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="49">Remove Filter/Sort</paragraph>
112</tablecell>
113</tablerow>
114</table>
115</section>
116<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US" l10n="U" oldref="21"><variable id="dnaftas">Choose <emph>Data - Filter - Hide AutoFilter</emph>

--- 28 unchanged lines hidden (view full) ---

145<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US" l10n="U" oldref="51">F12</paragraph>
146<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US" l10n="CHG" oldref="35">On <emph>Tools</emph> bar, click</paragraph>
147<section id="sygruppieren">
148<table id="tbl_id3154532">
149<tablerow>
150<tablecell colspan="" rowspan="">
151<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="E">
152<image id="img_id3153287" src="res/commandimagelist/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt>
158 </image></paragraph>
153</image></paragraph>
159</tablecell>
160<tablecell colspan="" rowspan="">
161<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG" oldref="36">Group</paragraph>
162</tablecell>
163</tablerow>
164</table>
165</section>
166</section>
167<section id="dnglgra">
168<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US" l10n="U" oldref="37">Choose <emph>Data - Group and Outline - Ungroup</emph>
169</paragraph>
170<paragraph role="paragraph" id="par_id3150892" xml-lang="en-US" l10n="U" oldref="52"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
171<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="CHG" oldref="38">On <emph>Tools</emph> bar, click</paragraph>
172<section id="sygruppierungaufheben">
173<table id="tbl_id3143223">
174<tablerow>
175<tablecell colspan="" rowspan="">
176<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="E">
177<image id="img_id3155914" src="res/commandimagelist/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt>
154</tablecell>
155<tablecell colspan="" rowspan="">
156<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG" oldref="36">Group</paragraph>
157</tablecell>
158</tablerow>
159</table>
160</section>
161</section>
162<section id="dnglgra">
163<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US" l10n="U" oldref="37">Choose <emph>Data - Group and Outline - Ungroup</emph>
164</paragraph>
165<paragraph role="paragraph" id="par_id3150892" xml-lang="en-US" l10n="U" oldref="52"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
166<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="CHG" oldref="38">On <emph>Tools</emph> bar, click</paragraph>
167<section id="sygruppierungaufheben">
168<table id="tbl_id3143223">
169<tablerow>
170<tablecell colspan="" rowspan="">
171<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="E">
172<image id="img_id3155914" src="res/commandimagelist/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt>
178 </image></paragraph>
173</image></paragraph>
179</tablecell>
180<tablecell colspan="" rowspan="">
181<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US" l10n="U" oldref="39">Ungroup</paragraph>
182</tablecell>
183</tablerow>
184</table>
185</section>
186</section>

--- 26 unchanged lines hidden --- 		174</tablecell>
175<tablecell colspan="" rowspan="">
176<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US" l10n="U" oldref="39">Ungroup</paragraph>
177</tablecell>
178</tablerow>
179</table>
180</section>
181</section>

--- 26 unchanged lines hidden ---