1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 502dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 602dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 702dbb15cSAndrew Rist * distributed with this work for additional information 802dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 902dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 1002dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 1102dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 1502dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 1602dbb15cSAndrew Rist * software distributed under the License is distributed on an 1702dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1802dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 1902dbb15cSAndrew Rist * specific language governing permissions and limitations 2002dbb15cSAndrew Rist * under the License. 21cdf0e10cSrcweir * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 24cdf0e10cSrcweir<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Data Menu</title> 28cdf0e10cSrcweir<filename>/text/scalc/00/00000412.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32*31402eadSmseidel<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1" l10n="U">Data Menu</paragraph> 33cdf0e10cSrcweir<paragraph role="paragraph" id="par_id8366954" xml-lang="en-US" l10n="NEW"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph> 34cdf0e10cSrcweir</variable></paragraph> 35*31402eadSmseidel<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US" l10n="U"><variable id="dbrbf">Choose <emph>Data - Define Range</emph> 36cdf0e10cSrcweir</variable></paragraph> 37*31402eadSmseidel<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U"><variable id="dbrba">Choose <emph>Data - Select Range</emph> 38cdf0e10cSrcweir</variable></paragraph> 39*31402eadSmseidel<paragraph role="paragraph" id="par_id3150443" xml-lang="en-US" l10n="U"><variable id="dnsrt">Choose <emph>Data - Sort</emph> 40cdf0e10cSrcweir</variable></paragraph> 41cdf0e10cSrcweir<section id="dnsosk"> 42*31402eadSmseidel<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U">Choose <emph>Data - Sort - Sort Criteria</emph> tab</paragraph> 43*31402eadSmseidel<paragraph role="paragraph" id="par_id3154516" xml-lang="en-US" l10n="CHG">On Standard bar, click</paragraph> 44cdf0e10cSrcweir<section id="sysortieren"> 45cdf0e10cSrcweir<table id="tbl_id3156023"> 46cdf0e10cSrcweir<tablerow> 47cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 48cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US" l10n="E"> 49cdf0e10cSrcweir<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> 50cdf0e10cSrcweir</image></paragraph> 51cdf0e10cSrcweir</tablecell> 52cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 53*31402eadSmseidel<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U">Sort Ascending</paragraph> 54cdf0e10cSrcweir</tablecell> 55cdf0e10cSrcweir</tablerow> 56cdf0e10cSrcweir<tablerow> 57cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 58cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="E"> 59cdf0e10cSrcweir<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> 60cdf0e10cSrcweir</image></paragraph> 61cdf0e10cSrcweir</tablecell> 62cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 63*31402eadSmseidel<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U">Sort Descending</paragraph> 64cdf0e10cSrcweir</tablecell> 65cdf0e10cSrcweir</tablerow> 66cdf0e10cSrcweir</table> 67cdf0e10cSrcweir</section> 68cdf0e10cSrcweir</section> 69*31402eadSmseidel<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab 70cdf0e10cSrcweir</variable></paragraph> 71*31402eadSmseidel<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U"><variable id="dnftr">Choose <emph>Data - Filter</emph> 72cdf0e10cSrcweir</variable></paragraph> 73cdf0e10cSrcweir<section id="dnfiafi"> 74*31402eadSmseidel<paragraph role="paragraph" id="par_id3148646" xml-lang="en-US" l10n="U">Choose <emph>Data - Filter - AutoFilter</emph> 75cdf0e10cSrcweir</paragraph> 76*31402eadSmseidel<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="CHG">On Tools bar or Table Data bar, click</paragraph> 77cdf0e10cSrcweir<section id="syautofilter"> 78cdf0e10cSrcweir<table id="tbl_id3155418"> 79cdf0e10cSrcweir<tablerow> 80cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 81cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="E"> 82cdf0e10cSrcweir<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> 83cdf0e10cSrcweir</image></paragraph> 84cdf0e10cSrcweir</tablecell> 85cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 86*31402eadSmseidel<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U">AutoFilter</paragraph> 87cdf0e10cSrcweir</tablecell> 88cdf0e10cSrcweir</tablerow> 89cdf0e10cSrcweir</table> 90cdf0e10cSrcweir</section> 91cdf0e10cSrcweir</section> 92*31402eadSmseidel<paragraph role="paragraph" id="par_id3156278" xml-lang="en-US" l10n="U"><variable id="dnfspz">Choose <emph>Data - Filter - Advanced Filter</emph> 93cdf0e10cSrcweir</variable></paragraph> 94cdf0e10cSrcweir<section id="filterzus"> 95*31402eadSmseidel<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U">Choose <emph>Data - Filter - Standard Filter - More>></emph> button</paragraph> 96*31402eadSmseidel<paragraph role="paragraph" id="par_id3155444" xml-lang="en-US" l10n="U">Choose <emph>Data - Filter - Advanced Filter - More>></emph> button</paragraph> 97cdf0e10cSrcweir</section> 98cdf0e10cSrcweir<section id="dnfief"> 99*31402eadSmseidel<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U">Choose <emph>Data - Filter - Remove Filter</emph> 100cdf0e10cSrcweir</paragraph> 101*31402eadSmseidel<paragraph role="paragraph" id="par_id3155961" xml-lang="en-US" l10n="CHG">On Table Data bar, click <emph>Remove Filter/Sort</emph> 102cdf0e10cSrcweir</paragraph> 103cdf0e10cSrcweir<table id="tbl_id3146919"> 104cdf0e10cSrcweir<tablerow> 105cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 106cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="E"> 107cdf0e10cSrcweir<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> 108cdf0e10cSrcweir</image></paragraph> 109cdf0e10cSrcweir</tablecell> 110cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 111*31402eadSmseidel<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U">Remove Filter/Sort</paragraph> 112cdf0e10cSrcweir</tablecell> 113cdf0e10cSrcweir</tablerow> 114cdf0e10cSrcweir</table> 115cdf0e10cSrcweir</section> 116*31402eadSmseidel<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US" l10n="U"><variable id="dnaftas">Choose <emph>Data - Filter - Hide AutoFilter</emph> 117cdf0e10cSrcweir</variable></paragraph> 118*31402eadSmseidel<paragraph role="paragraph" id="par_id3166424" xml-lang="en-US" l10n="U"><variable id="dntegs">Choose <emph>Data - Subtotals</emph> 119cdf0e10cSrcweir</variable></paragraph> 120*31402eadSmseidel<paragraph role="paragraph" id="par_id3154574" xml-lang="en-US" l10n="U"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs 121cdf0e10cSrcweir</variable></paragraph> 122*31402eadSmseidel<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US" l10n="U"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab 123cdf0e10cSrcweir</variable></paragraph> 124*31402eadSmseidel<paragraph role="paragraph" id="par_id3145133" xml-lang="en-US" l10n="U"><variable id="datengueltig">Choose <emph>Data - Validity</emph> 125cdf0e10cSrcweir</variable></paragraph> 126*31402eadSmseidel<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab 127cdf0e10cSrcweir</variable></paragraph> 128*31402eadSmseidel<paragraph role="paragraph" id="par_id3150367" xml-lang="en-US" l10n="U"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab 129cdf0e10cSrcweir</variable></paragraph> 130*31402eadSmseidel<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US" l10n="U"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab 131cdf0e10cSrcweir</variable></paragraph> 132*31402eadSmseidel<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph> 133cdf0e10cSrcweir</variable></paragraph> 134*31402eadSmseidel<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="U"><variable id="dnksd">Choose <emph>Data - Consolidate</emph> 135cdf0e10cSrcweir</variable></paragraph> 136*31402eadSmseidel<paragraph role="paragraph" id="par_id3148701" xml-lang="en-US" l10n="CHG"><variable id="dngld">Choose <emph>Data - Group and Outline</emph> 137cdf0e10cSrcweir</variable></paragraph> 138*31402eadSmseidel<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US" l10n="U"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph> 139cdf0e10cSrcweir</variable></paragraph> 140*31402eadSmseidel<paragraph role="paragraph" id="par_id3159223" xml-lang="en-US" l10n="U"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph> 141cdf0e10cSrcweir</variable></paragraph> 142cdf0e10cSrcweir<section id="dnglgr"> 143*31402eadSmseidel<paragraph role="paragraph" id="par_id3146870" xml-lang="en-US" l10n="U">Choose <emph>Data - Group and Outline - Group</emph> 144cdf0e10cSrcweir</paragraph> 145*31402eadSmseidel<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US" l10n="U">F12</paragraph> 146*31402eadSmseidel<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US" l10n="CHG">On <emph>Tools</emph> bar, click</paragraph> 147cdf0e10cSrcweir<section id="sygruppieren"> 148cdf0e10cSrcweir<table id="tbl_id3154532"> 149cdf0e10cSrcweir<tablerow> 150cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 151cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="E"> 152cdf0e10cSrcweir<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> 153cdf0e10cSrcweir</image></paragraph> 154cdf0e10cSrcweir</tablecell> 155cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 156*31402eadSmseidel<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG">Group</paragraph> 157cdf0e10cSrcweir</tablecell> 158cdf0e10cSrcweir</tablerow> 159cdf0e10cSrcweir</table> 160cdf0e10cSrcweir</section> 161cdf0e10cSrcweir</section> 162cdf0e10cSrcweir<section id="dnglgra"> 163*31402eadSmseidel<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US" l10n="U">Choose <emph>Data - Group and Outline - Ungroup</emph> 164cdf0e10cSrcweir</paragraph> 165*31402eadSmseidel<paragraph role="paragraph" id="par_id3150892" xml-lang="en-US" l10n="U"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph> 166*31402eadSmseidel<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="CHG">On <emph>Tools</emph> bar, click</paragraph> 167cdf0e10cSrcweir<section id="sygruppierungaufheben"> 168cdf0e10cSrcweir<table id="tbl_id3143223"> 169cdf0e10cSrcweir<tablerow> 170cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 171cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="E"> 172cdf0e10cSrcweir<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> 173cdf0e10cSrcweir</image></paragraph> 174cdf0e10cSrcweir</tablecell> 175cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 176*31402eadSmseidel<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US" l10n="U">Ungroup</paragraph> 177cdf0e10cSrcweir</tablecell> 178cdf0e10cSrcweir</tablerow> 179cdf0e10cSrcweir</table> 180cdf0e10cSrcweir</section> 181cdf0e10cSrcweir</section> 182*31402eadSmseidel<paragraph role="paragraph" id="par_id3153008" xml-lang="en-US" l10n="U"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph> 183cdf0e10cSrcweir</variable></paragraph> 184*31402eadSmseidel<paragraph role="paragraph" id="par_id3154709" xml-lang="en-US" l10n="U"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove</emph> 185cdf0e10cSrcweir</variable></paragraph> 186cdf0e10cSrcweir<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) 187cdf0e10cSrcweir</variable></paragraph> 188*31402eadSmseidel<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US" l10n="CHG"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph> 189cdf0e10cSrcweir</variable></paragraph> 190*31402eadSmseidel<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="CHG"><variable id="dndpa">Choose <emph>Data - Pivot Table - Create</emph> 191cdf0e10cSrcweir</variable></paragraph> 192*31402eadSmseidel<paragraph role="paragraph" id="par_id3147558" xml-lang="en-US" l10n="CHG"><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>. 193cdf0e10cSrcweir</variable></paragraph> 194cdf0e10cSrcweir<section id="dndpaz"> 195*31402eadSmseidel<paragraph role="paragraph" id="par_id3153297" xml-lang="en-US" l10n="CHG">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Current selection</emph>.</paragraph> 196*31402eadSmseidel<paragraph role="paragraph" id="par_id3145118" xml-lang="en-US" l10n="CHG">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> 197cdf0e10cSrcweir</section> 198*31402eadSmseidel<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="CHG"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph> 199cdf0e10cSrcweir</variable></paragraph> 200*31402eadSmseidel<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="CHG"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph> 201cdf0e10cSrcweir</variable></paragraph> 202*31402eadSmseidel<paragraph role="paragraph" id="par_id3150397" xml-lang="en-US" l10n="U"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph> 203cdf0e10cSrcweir</variable></paragraph> 204cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US" l10n="CHG"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph> 205cdf0e10cSrcweir</variable></paragraph> 206cdf0e10cSrcweir</body> 207cdf0e10cSrcweir</helpdocument> 208
