1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: main0112.xhp,v $
17 * This file is part of OpenOffice.org.
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.
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).
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.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textscalcmain0112xml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">Data
</title>
42 <filename>/text/scalc/main0112.xhp
</filename>
47 <bookmark xml-lang=
"en-US" branch=
"hid/.uno:DataMenu" id=
"bm_id9612414" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3153254" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1"><link href=
"text/scalc/main0112.xhp" name=
"Data">Data
</link></paragraph>
48 <paragraph role=
"paragraph" id=
"par_id3147264" xml-lang=
"en-US" l10n=
"CHG" oldref=
"2"><ahelp hid=
".">Use the
<emph>Data
</emph>menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and open the DataPilot.
</ahelp></paragraph>
50 <paragraph role=
"heading" id=
"hd_id3150400" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3"><link href=
"text/scalc/01/12010000.xhp" name=
"Define Range">Define Range
</link></paragraph>
51 <embed href=
"text/scalc/01/12010000.xhp#bereichtext"/>
52 <paragraph role=
"heading" id=
"hd_id3125863" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"4"><link href=
"text/scalc/01/12020000.xhp" name=
"Select Range">Select Range
</link></paragraph>
53 <embed href=
"text/scalc/01/12020000.xhp#bereichwaehlen"/>
54 <paragraph role=
"heading" id=
"hd_id3153726" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5"><link href=
"text/scalc/01/12030000.xhp" name=
"Sort">Sort
</link></paragraph>
55 <embed href=
"text/scalc/01/12030000.xhp#sorttext"/>
56 <embed href=
"text/scalc/01/12040000.xhp#filter"/>
57 <paragraph role=
"heading" id=
"hd_id3153142" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"6"><link href=
"text/scalc/01/12050000.xhp" name=
"Subtotals">Subtotals
</link></paragraph>
58 <embed href=
"text/scalc/01/12050000.xhp#teilergebnisse"/>
59 <paragraph role=
"heading" id=
"hd_id3151073" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"10"><link href=
"text/scalc/01/12120000.xhp" name=
"Validity">Validity
</link></paragraph>
60 <embed href=
"text/scalc/01/12120000.xhp#gueltigkeit"/>
61 <paragraph role=
"heading" id=
"hd_id3145254" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"7"><link href=
"text/scalc/01/12060000.xhp" name=
"Multiple Operations">Multiple Operations
</link></paragraph>
62 <embed href=
"text/scalc/01/12060000.xhp#mehrfachoperationen"/>
63 <paragraph role=
"heading" id=
"hd_id1387066" xml-lang=
"en-US" level=
"2" l10n=
"NEW"><link href=
"text/scalc/01/text2columns.xhp">Text to Columns
</link></paragraph>
64 <embed href=
"text/scalc/01/text2columns.xhp#text2columns"/>
65 <paragraph role=
"heading" id=
"hd_id3150717" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"8"><link href=
"text/scalc/01/12070000.xhp" name=
"Consolidate">Consolidate
</link></paragraph>
66 <embed href=
"text/scalc/01/12070000.xhp#konsolidieren"/>
67 <embed href=
"text/scalc/01/12080000.xhp#gliederung"/>
68 <embed href=
"text/scalc/01/12090000.xhp#datenpilot"/>
69 <paragraph role=
"heading" id=
"hd_id3154754" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"9"><link href=
"text/scalc/01/12100000.xhp" name=
"Refresh Range">Refresh Range
</link></paragraph>
70 <embed href=
"text/scalc/01/12100000.xhp#aktualisieren"/>