1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir 5*cdf0e10cSrcweir<!-- 6*cdf0e10cSrcweir *********************************************************************** 7*cdf0e10cSrcweir * 8*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9*cdf0e10cSrcweir * 10*cdf0e10cSrcweir * Copyright 2000, 2011 Oracle and/or its affiliates. 11*cdf0e10cSrcweir * 12*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 13*cdf0e10cSrcweir * 14*cdf0e10cSrcweir * This file is part of OpenOffice.org. 15*cdf0e10cSrcweir * 16*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 17*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 18*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 19*cdf0e10cSrcweir * 20*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 21*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 22*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 24*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 27*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 28*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 29*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 30*cdf0e10cSrcweir * 31*cdf0e10cSrcweir ************************************************************************ 32*cdf0e10cSrcweir --> 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir 35*cdf0e10cSrcweir <helpdocument version="1.0"> 36*cdf0e10cSrcweir<meta> 37*cdf0e10cSrcweir<topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH"> 38*cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Data Menu</title> 39*cdf0e10cSrcweir<filename>/text/scalc/00/00000412.xhp</filename> 40*cdf0e10cSrcweir</topic> 41*cdf0e10cSrcweir</meta> 42*cdf0e10cSrcweir<body> 43*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Menu</paragraph> 44*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id8366954" xml-lang="en-US" l10n="NEW"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph> 45*cdf0e10cSrcweir</variable></paragraph> 46*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US" l10n="U" oldref="3"><variable id="dbrbf">Choose <emph>Data - Define Range</emph> 47*cdf0e10cSrcweir</variable></paragraph> 48*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U" oldref="4"><variable id="dbrba">Choose <emph>Data - Select Range</emph> 49*cdf0e10cSrcweir</variable></paragraph> 50*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150443" xml-lang="en-US" l10n="U" oldref="5"><variable id="dnsrt">Choose <emph>Data - Sort</emph> 51*cdf0e10cSrcweir</variable></paragraph> 52*cdf0e10cSrcweir<section id="dnsosk"> 53*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Data - Sort - Sort Criteria</emph> tab</paragraph> 54*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154516" xml-lang="en-US" l10n="CHG" oldref="7">On Standard bar, click</paragraph> 55*cdf0e10cSrcweir<section id="sysortieren"> 56*cdf0e10cSrcweir<table id="tbl_id3156023"> 57*cdf0e10cSrcweir<tablerow> 58*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 59*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US" l10n="E"> 60*cdf0e10cSrcweir<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> 61*cdf0e10cSrcweir </image></paragraph> 62*cdf0e10cSrcweir</tablecell> 63*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 64*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="8">Sort Ascending</paragraph> 65*cdf0e10cSrcweir</tablecell> 66*cdf0e10cSrcweir</tablerow> 67*cdf0e10cSrcweir<tablerow> 68*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 69*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="E"> 70*cdf0e10cSrcweir<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> 71*cdf0e10cSrcweir </image></paragraph> 72*cdf0e10cSrcweir</tablecell> 73*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 74*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="9">Sort Descending</paragraph> 75*cdf0e10cSrcweir</tablecell> 76*cdf0e10cSrcweir</tablerow> 77*cdf0e10cSrcweir</table> 78*cdf0e10cSrcweir</section> 79*cdf0e10cSrcweir</section> 80*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="10"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab 81*cdf0e10cSrcweir</variable></paragraph> 82*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="11"><variable id="dnftr">Choose <emph>Data - Filter</emph> 83*cdf0e10cSrcweir</variable></paragraph> 84*cdf0e10cSrcweir<section id="dnfiafi"> 85*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148646" xml-lang="en-US" l10n="U" oldref="12">Choose <emph>Data - Filter - AutoFilter</emph> 86*cdf0e10cSrcweir</paragraph> 87*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="CHG" oldref="13">On Tools bar or Table Data bar, click</paragraph> 88*cdf0e10cSrcweir<section id="syautofilter"> 89*cdf0e10cSrcweir<table id="tbl_id3155418"> 90*cdf0e10cSrcweir<tablerow> 91*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 92*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="E"> 93*cdf0e10cSrcweir<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> 94*cdf0e10cSrcweir </image></paragraph> 95*cdf0e10cSrcweir</tablecell> 96*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 97*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="14">AutoFilter</paragraph> 98*cdf0e10cSrcweir</tablecell> 99*cdf0e10cSrcweir</tablerow> 100*cdf0e10cSrcweir</table> 101*cdf0e10cSrcweir</section> 102*cdf0e10cSrcweir</section> 103*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3156278" xml-lang="en-US" l10n="U" oldref="17"><variable id="dnfspz">Choose <emph>Data - Filter - Advanced Filter</emph> 104*cdf0e10cSrcweir</variable></paragraph> 105*cdf0e10cSrcweir<section id="filterzus"> 106*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Data - Filter - Standard Filter - More>></emph> button</paragraph> 107*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155444" xml-lang="en-US" l10n="U" oldref="19">Choose <emph>Data - Filter - Advanced Filter - More>></emph> button</paragraph> 108*cdf0e10cSrcweir</section> 109*cdf0e10cSrcweir<section id="dnfief"> 110*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="20">Choose <emph>Data - Filter - Remove Filter</emph> 111*cdf0e10cSrcweir</paragraph> 112*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155961" xml-lang="en-US" l10n="CHG" oldref="48">On Table Data bar, click <emph>Remove Filter/Sort</emph> 113*cdf0e10cSrcweir</paragraph> 114*cdf0e10cSrcweir<table id="tbl_id3146919"> 115*cdf0e10cSrcweir<tablerow> 116*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 117*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="E"> 118*cdf0e10cSrcweir<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> 119*cdf0e10cSrcweir </image></paragraph> 120*cdf0e10cSrcweir</tablecell> 121*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 122*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="49">Remove Filter/Sort</paragraph> 123*cdf0e10cSrcweir</tablecell> 124*cdf0e10cSrcweir</tablerow> 125*cdf0e10cSrcweir</table> 126*cdf0e10cSrcweir</section> 127*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US" l10n="U" oldref="21"><variable id="dnaftas">Choose <emph>Data - Filter - Hide AutoFilter</emph> 128*cdf0e10cSrcweir</variable></paragraph> 129*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3166424" xml-lang="en-US" l10n="U" oldref="22"><variable id="dntegs">Choose <emph>Data - Subtotals</emph> 130*cdf0e10cSrcweir</variable></paragraph> 131*cdf0e10cSrcweir<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 132*cdf0e10cSrcweir</variable></paragraph> 133*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US" l10n="U" oldref="24"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab 134*cdf0e10cSrcweir</variable></paragraph> 135*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145133" xml-lang="en-US" l10n="U" oldref="25"><variable id="datengueltig">Choose <emph>Data - Validity</emph> 136*cdf0e10cSrcweir</variable></paragraph> 137*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab 138*cdf0e10cSrcweir</variable></paragraph> 139*cdf0e10cSrcweir<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 140*cdf0e10cSrcweir</variable></paragraph> 141*cdf0e10cSrcweir<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 142*cdf0e10cSrcweir</variable></paragraph> 143*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="29"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph> 144*cdf0e10cSrcweir</variable></paragraph> 145*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="U" oldref="30"><variable id="dnksd">Choose <emph>Data - Consolidate</emph> 146*cdf0e10cSrcweir</variable></paragraph> 147*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148701" xml-lang="en-US" l10n="CHG" oldref="31"><variable id="dngld">Choose <emph>Data - Group and Outline</emph> 148*cdf0e10cSrcweir</variable></paragraph> 149*cdf0e10cSrcweir<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> 150*cdf0e10cSrcweir</variable></paragraph> 151*cdf0e10cSrcweir<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> 152*cdf0e10cSrcweir</variable></paragraph> 153*cdf0e10cSrcweir<section id="dnglgr"> 154*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146870" xml-lang="en-US" l10n="U" oldref="34">Choose <emph>Data - Group and Outline - Group</emph> 155*cdf0e10cSrcweir</paragraph> 156*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US" l10n="U" oldref="51">F12</paragraph> 157*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US" l10n="CHG" oldref="35">On <emph>Tools</emph> bar, click</paragraph> 158*cdf0e10cSrcweir<section id="sygruppieren"> 159*cdf0e10cSrcweir<table id="tbl_id3154532"> 160*cdf0e10cSrcweir<tablerow> 161*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 162*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="E"> 163*cdf0e10cSrcweir<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> 164*cdf0e10cSrcweir </image></paragraph> 165*cdf0e10cSrcweir</tablecell> 166*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 167*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG" oldref="36">Group</paragraph> 168*cdf0e10cSrcweir</tablecell> 169*cdf0e10cSrcweir</tablerow> 170*cdf0e10cSrcweir</table> 171*cdf0e10cSrcweir</section> 172*cdf0e10cSrcweir</section> 173*cdf0e10cSrcweir<section id="dnglgra"> 174*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US" l10n="U" oldref="37">Choose <emph>Data - Group and Outline - Ungroup</emph> 175*cdf0e10cSrcweir</paragraph> 176*cdf0e10cSrcweir<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> 177*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="CHG" oldref="38">On <emph>Tools</emph> bar, click</paragraph> 178*cdf0e10cSrcweir<section id="sygruppierungaufheben"> 179*cdf0e10cSrcweir<table id="tbl_id3143223"> 180*cdf0e10cSrcweir<tablerow> 181*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 182*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="E"> 183*cdf0e10cSrcweir<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> 184*cdf0e10cSrcweir </image></paragraph> 185*cdf0e10cSrcweir</tablecell> 186*cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 187*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US" l10n="U" oldref="39">Ungroup</paragraph> 188*cdf0e10cSrcweir</tablecell> 189*cdf0e10cSrcweir</tablerow> 190*cdf0e10cSrcweir</table> 191*cdf0e10cSrcweir</section> 192*cdf0e10cSrcweir</section> 193*cdf0e10cSrcweir<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> 194*cdf0e10cSrcweir</variable></paragraph> 195*cdf0e10cSrcweir<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> 196*cdf0e10cSrcweir</variable></paragraph> 197*cdf0e10cSrcweir<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) 198*cdf0e10cSrcweir</variable></paragraph> 199*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US" l10n="CHG" oldref="42"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph> 200*cdf0e10cSrcweir</variable></paragraph> 201*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="CHG" oldref="43"><variable id="dndpa">Choose <emph>Data - Pivot Table - Create</emph> 202*cdf0e10cSrcweir</variable></paragraph> 203*cdf0e10cSrcweir<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>. 204*cdf0e10cSrcweir</variable></paragraph> 205*cdf0e10cSrcweir<section id="dndpaz"> 206*cdf0e10cSrcweir<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> 207*cdf0e10cSrcweir<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> 208*cdf0e10cSrcweir</section> 209*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="CHG" oldref="44"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph> 210*cdf0e10cSrcweir</variable></paragraph> 211*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="CHG" oldref="45"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph> 212*cdf0e10cSrcweir</variable></paragraph> 213*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150397" xml-lang="en-US" l10n="U" oldref="46"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph> 214*cdf0e10cSrcweir</variable></paragraph> 215*cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US" l10n="CHG"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph> 216*cdf0e10cSrcweir</variable></paragraph> 217*cdf0e10cSrcweir</body> 218*cdf0e10cSrcweir</helpdocument> 219
