helpcontent2/source/text/scalc/00/00000412.xhp

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