1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!--*********************************************************** 6 * 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 14 * 15 * http://www.apache.org/licenses/LICENSE-2.0 16 * 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. 23 * 24 ***********************************************************--> 25 26 27 28 29 <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> 38<paragraph role="paragraph" id="par_id8366954" xml-lang="en-US" l10n="NEW"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph> 39</variable></paragraph> 40<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US" l10n="U" oldref="3"><variable id="dbrbf">Choose <emph>Data - Define Range</emph> 41</variable></paragraph> 42<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U" oldref="4"><variable id="dbrba">Choose <emph>Data - Select Range</emph> 43</variable></paragraph> 44<paragraph role="paragraph" id="par_id3150443" xml-lang="en-US" l10n="U" oldref="5"><variable id="dnsrt">Choose <emph>Data - Sort</emph> 45</variable></paragraph> 46<section id="dnsosk"> 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> 55 </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> 65 </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> 74<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="10"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab 75</variable></paragraph> 76<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="11"><variable id="dnftr">Choose <emph>Data - Filter</emph> 77</variable></paragraph> 78<section id="dnfiafi"> 79<paragraph role="paragraph" id="par_id3148646" xml-lang="en-US" l10n="U" oldref="12">Choose <emph>Data - Filter - AutoFilter</emph> 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> 88 </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> 97<paragraph role="paragraph" id="par_id3156278" xml-lang="en-US" l10n="U" oldref="17"><variable id="dnfspz">Choose <emph>Data - Filter - Advanced Filter</emph> 98</variable></paragraph> 99<section id="filterzus"> 100<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Data - Filter - Standard Filter - More>></emph> button</paragraph> 101<paragraph role="paragraph" id="par_id3155444" xml-lang="en-US" l10n="U" oldref="19">Choose <emph>Data - Filter - Advanced Filter - More>></emph> button</paragraph> 102</section> 103<section id="dnfief"> 104<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="20">Choose <emph>Data - Filter - Remove Filter</emph> 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> 113 </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> 122</variable></paragraph> 123<paragraph role="paragraph" id="par_id3166424" xml-lang="en-US" l10n="U" oldref="22"><variable id="dntegs">Choose <emph>Data - Subtotals</emph> 124</variable></paragraph> 125<paragraph role="paragraph" id="par_id3154574" xml-lang="en-US" l10n="U" oldref="23"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs 126</variable></paragraph> 127<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US" l10n="U" oldref="24"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab 128</variable></paragraph> 129<paragraph role="paragraph" id="par_id3145133" xml-lang="en-US" l10n="U" oldref="25"><variable id="datengueltig">Choose <emph>Data - Validity</emph> 130</variable></paragraph> 131<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab 132</variable></paragraph> 133<paragraph role="paragraph" id="par_id3150367" xml-lang="en-US" l10n="U" oldref="27"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab 134</variable></paragraph> 135<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US" l10n="U" oldref="28"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab 136</variable></paragraph> 137<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="29"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph> 138</variable></paragraph> 139<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="U" oldref="30"><variable id="dnksd">Choose <emph>Data - Consolidate</emph> 140</variable></paragraph> 141<paragraph role="paragraph" id="par_id3148701" xml-lang="en-US" l10n="CHG" oldref="31"><variable id="dngld">Choose <emph>Data - Group and Outline</emph> 142</variable></paragraph> 143<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US" l10n="U" oldref="32"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph> 144</variable></paragraph> 145<paragraph role="paragraph" id="par_id3159223" xml-lang="en-US" l10n="U" oldref="33"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph> 146</variable></paragraph> 147<section id="dnglgr"> 148<paragraph role="paragraph" id="par_id3146870" xml-lang="en-US" l10n="U" oldref="34">Choose <emph>Data - Group and Outline - Group</emph> 149</paragraph> 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> 158 </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> 178 </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> 187<paragraph role="paragraph" id="par_id3153008" xml-lang="en-US" l10n="U" oldref="40"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph> 188</variable></paragraph> 189<paragraph role="paragraph" id="par_id3154709" xml-lang="en-US" l10n="U" oldref="41"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove</emph> 190</variable></paragraph> 191<paragraph role="paragraph" id="par_id1774346" xml-lang="en-US" l10n="CHG"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables) 192</variable></paragraph> 193<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US" l10n="CHG" oldref="42"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph> 194</variable></paragraph> 195<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="CHG" oldref="43"><variable id="dndpa">Choose <emph>Data - Pivot Table - Create</emph> 196</variable></paragraph> 197<paragraph role="paragraph" id="par_id3147558" xml-lang="en-US" l10n="CHG" oldref="53"><variable id="dndq">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>. 198</variable></paragraph> 199<section id="dndpaz"> 200<paragraph role="paragraph" id="par_id3153297" xml-lang="en-US" l10n="CHG" oldref="50">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Current selection</emph>.</paragraph> 201<paragraph role="paragraph" id="par_id3145118" xml-lang="en-US" l10n="CHG" oldref="54">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph> 202</section> 203<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="CHG" oldref="44"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph> 204</variable></paragraph> 205<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="CHG" oldref="45"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph> 206</variable></paragraph> 207<paragraph role="paragraph" id="par_id3150397" xml-lang="en-US" l10n="U" oldref="46"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph> 208</variable></paragraph> 209<paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US" l10n="CHG"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph> 210</variable></paragraph> 211</body> 212</helpdocument> 213
