summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/00
diff options
context:
space:
mode:
authorFrank Peters <fpe@openoffice.org>2004-08-18 09:59:46 +0000
committerFrank Peters <fpe@openoffice.org>2004-08-18 09:59:46 +0000
commit4f48bcc7937fbc586af7720d4225768ee6913e2a (patch)
tree431c32101c9b8349fe8f420615df796296d69a90 /helpcontent2/source/text/scalc/00
#i33146# Initial checkin
Diffstat (limited to 'helpcontent2/source/text/scalc/00')
-rwxr-xr-xhelpcontent2/source/text/scalc/00/00000004.xhp76
-rwxr-xr-xhelpcontent2/source/text/scalc/00/00000402.xhp96
-rwxr-xr-xhelpcontent2/source/text/scalc/00/00000403.xhp75
-rw-r--r--helpcontent2/source/text/scalc/00/00000404.xhp225
-rw-r--r--helpcontent2/source/text/scalc/00/00000405.xhp179
-rwxr-xr-xhelpcontent2/source/text/scalc/00/00000406.xhp101
-rwxr-xr-xhelpcontent2/source/text/scalc/00/00000407.xhp73
-rw-r--r--helpcontent2/source/text/scalc/00/00000412.xhp246
-rw-r--r--helpcontent2/source/text/scalc/00/makefile.mk47
9 files changed, 1118 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/00/00000004.xhp b/helpcontent2/source/text/scalc/00/00000004.xhp
new file mode 100755
index 000000000..8e799ff43
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000004.xhp
@@ -0,0 +1,76 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000004xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">To access this function...</title>
+<filename>/text/scalc/00/00000004.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-05-11T14:45:22">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="1" l10n="U" oldref="1">
+<variable id="wie">To access this function...
+</variable></paragraph>
+<paragraph role="paragraph" id="par_idN1056E" xml-lang="en-US" l10n="NEW">
+<variable id="moreontop">More explanations on top of this page.
+</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000402.xhp b/helpcontent2/source/text/scalc/00/00000402.xhp
new file mode 100755
index 000000000..7f62968b6
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000402.xhp
@@ -0,0 +1,96 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************--><helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000402xml" indexer="exclude" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Edit Menu</title>
+<filename>/text/scalc/00/00000402.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+
+
+ <paragraph role="heading" level="1" id="hd_id3147303" l10n="U" xml-lang="en-US" oldref="1">Edit Menu</paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3155555" xml-lang="en-US" oldref="2"><variable id="kopffuss">Choose <emph>Edit - Headers &amp; Footers</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3159233" xml-lang="en-US" oldref="3"><variable id="bkopfzeile">Choose <emph>Edit - Headers &amp; Footers - Header/Footer</emph> tabs</variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3150443" xml-lang="en-US" oldref="4"><variable id="bausfullen">Choose <emph>Edit - Fill</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3143267" xml-lang="en-US" oldref="5"><variable id="bausunten">Choose <emph>Edit - Fill - Down</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3153880" xml-lang="en-US" oldref="6"><variable id="bausrechts">Choose <emph>Edit - Fill - Right</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3151245" xml-lang="en-US" oldref="7"><variable id="bausoben">Choose <emph>Edit - Fill - Up</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3145068" xml-lang="en-US" oldref="8"><variable id="bauslinks">Choose <emph>Edit - Fill - Left</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3150400" xml-lang="en-US" oldref="9"><variable id="baustab">Choose <emph>Edit - Fill - Sheet</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3154910" xml-lang="en-US" oldref="10"><variable id="bausreihe">Choose <emph>Edit - Fill - Series</emph></variable></paragraph>
+ <section id="binhalt">
+ <paragraph l10n="U" role="paragraph" id="par_id3154123" xml-lang="en-US" oldref="11">Choose <emph>Edit - Delete Contents</emph></paragraph>
+ <paragraph role="paragraph" id="par_id3145785" l10n="U" xml-lang="en-US" oldref="20">Delete key</paragraph>
+ </section>
+ <paragraph l10n="U" role="paragraph" id="par_id3150011" xml-lang="en-US" oldref="12"><variable id="bzelo">Choose <emph>Edit - Delete Cells</emph></variable></paragraph>
+ <section id="btaloes">
+ <paragraph l10n="U" role="paragraph" id="par_id3153951" xml-lang="en-US" oldref="13">Choose <emph>Edit – Sheet - Delete</emph></paragraph>
+ <paragraph role="paragraph" id="par_id3155306" l10n="U" xml-lang="en-US" oldref="18">Open context menu for a sheet tab</paragraph>
+ </section>
+ <section id="btaverko">
+ <paragraph l10n="U" role="paragraph" id="par_id3146119" xml-lang="en-US" oldref="14">Choose <emph>Edit – Sheets – Move/Copy</emph></paragraph>
+ <paragraph role="paragraph" id="par_id3148645" l10n="U" xml-lang="en-US" oldref="19">Open context menu for a sheet tab</paragraph>
+ </section>
+ <paragraph l10n="U" role="paragraph" id="par_id3153093" xml-lang="en-US" oldref="15"><variable id="bmaumloe">Choose <emph>Edit - Delete Manual Break</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3153191" xml-lang="en-US" oldref="16"><variable id="bzeilum">Choose <emph>Edit - Delete Manual Break - Row Break</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3145645" xml-lang="en-US" oldref="17"><variable id="bspaum">Choose <emph>Edit - Delete Manual Break - Column Break</emph></variable></paragraph>
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000403.xhp b/helpcontent2/source/text/scalc/00/00000403.xhp
new file mode 100755
index 000000000..a75b45a09
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000403.xhp
@@ -0,0 +1,75 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************--><helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000403xml" indexer="exclude" status="PUBLISH">
+<title xml-lang="en-US" id="tit">View Menu</title>
+<filename>/text/scalc/00/00000403.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+
+
+ <paragraph role="heading" level="1" id="hd_id3145673" l10n="U" xml-lang="en-US" oldref="1">View Menu</paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3150275" xml-lang="en-US" oldref="2"><variable id="aspze">Choose <emph>View - Column &amp; Row Headers</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3154514" xml-lang="en-US" oldref="3"><variable id="awehe">Choose <emph>View - Value Highlighting</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3148947" xml-lang="en-US" oldref="4"><variable id="rechenleiste">Choose <emph>View - Toolbars - Formula Bar</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3148663" xml-lang="en-US" oldref="5"><variable id="seumvo">Choose <emph>View - Page Break Preview</emph></variable></paragraph>
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000404.xhp b/helpcontent2/source/text/scalc/00/00000404.xhp
new file mode 100644
index 000000000..62836c829
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000404.xhp
@@ -0,0 +1,225 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Insert Menu</title>
+<filename>/text/scalc/00/00000404.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-07-22T14:25:57">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Menu</paragraph>
+<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US" l10n="U" oldref="36"><variable id="eimaum">Choose <emph>Insert - Manual Break</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US" l10n="U" oldref="2"><variable id="eimaumze">Choose <emph>Insert - Manual Break - Row Break</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US" l10n="U" oldref="3"><variable id="eimaumsp">Choose <emph>Insert - Manual Break - Column Break</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US" l10n="U" oldref="4">Choose <emph>Insert - Cells</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US" l10n="U" oldref="5">Open <emph>Insert Cells</emph> floating toolbar from main toolbar:</paragraph>
+<section id="syzelleneinfuegen">
+<table id="tbl_id3148550">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="E">
+<image id="img_id3154365" src="res/commandimagelist/sc_inscellsctrl.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154365" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U" oldref="6">Insert Cells</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syzellenunten">
+<table id="tbl_id3159486">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="E">
+<image id="img_id3145364" src="res/commandimagelist/sc_insertcellsdown.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145364" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US" l10n="U" oldref="7">Insert Cells Down</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syzellenrechts">
+<table id="tbl_id3148575">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US" l10n="E">
+<image id="img_id3154942" src="res/commandimagelist/sc_insertcellsright.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154942" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="8">Insert Cells Right</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syzeilenganze">
+<table id="tbl_id3154015">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US" l10n="E">
+<image id="img_id3153710" src="res/commandimagelist/sc_insertrows.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153710" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US" l10n="U" oldref="9">Insert Rows</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syspaltenganze">
+<table id="tbl_id3147338">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US" l10n="E">
+<image id="img_id3145232" src="res/commandimagelist/sc_insertcolumns.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145232" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US" l10n="U" oldref="10">Insert Columns</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="U" oldref="11"><variable id="eizei">Choose <emph>Insert - Rows</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="12"><variable id="eispa">Choose <emph>Insert - Columns</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="13"><variable id="eitab">Choose <emph>Insert - Sheet</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US" l10n="NEW"><variable id="eitabfile">Choose <emph>Insert - Sheet from file</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US" l10n="U" oldref="14">Choose <emph>Insert - Function</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3152582" xml-lang="en-US" l10n="U" oldref="34"><switchinline select="sys"><caseinline select="MAC">Command
+</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
+<paragraph role="paragraph" id="par_id3153269" xml-lang="en-US" l10n="U" oldref="15">On Formula Bar, click</paragraph>
+<section id="syfunktionsautopilot">
+<table id="tbl_id3145258">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US" l10n="E">
+<image id="img_id3150884" src="sw/imglst/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150884" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="U" oldref="16">Open Function Wizard</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="U" oldref="17"><variable id="eikada">Open Function Wizard - Category <emph>Database</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="U" oldref="18"><variable id="eikadaze">Open Function Wizard - Category <emph>Date&amp;Time</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3151334" xml-lang="en-US" l10n="U" oldref="19"><variable id="eikafi">Open Function Wizard - Category <emph>Financial</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US" l10n="U" oldref="20"><variable id="eikain">Open Function Wizard - Category <emph>Information</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3159173" xml-lang="en-US" l10n="U" oldref="21"><variable id="eikalo">Open Function Wizard - Category <emph>Logical</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153914" xml-lang="en-US" l10n="U" oldref="22"><variable id="eikama">Open Function Wizard - Category <emph>Mathematical</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="U" oldref="23"><variable id="eikamatrix">Open Function Wizard - Category <emph>Array</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3157978" xml-lang="en-US" l10n="U" oldref="24"><variable id="eikasta">Open Function Wizard - Category <emph>Statistical</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156016" xml-lang="en-US" l10n="U" oldref="25"><variable id="eikatext">Open Function Wizard - Category <emph>Text</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3147075" xml-lang="en-US" l10n="U" oldref="26"><variable id="efefft">Open Function Wizard - Category <emph>Spreadsheet</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="U" oldref="27"><variable id="addin">Open Function Wizard - Category <emph>Add-In</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154059" xml-lang="en-US" l10n="U" oldref="38"><variable id="addinana">Function Wizard - Add-in category
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="33"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Names</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US" l10n="CHG" oldref="37"><variable id="eiextdata">Choose <emph>Insert - Link to External data</emph>
+</variable></paragraph>
+<section id="einafe">
+<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Insert - Names - Define</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US" l10n="U" oldref="35"><switchinline select="sys"><caseinline select="MAC">Command
+</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Insert - Names - Insert</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Insert - Names - Create</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Insert - Names - Labels</emph>
+</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000405.xhp b/helpcontent2/source/text/scalc/00/00000405.xhp
new file mode 100644
index 000000000..e48d940b4
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000405.xhp
@@ -0,0 +1,179 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000405xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Format Menu</title>
+<filename>/text/scalc/00/00000405.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-05-05T12:54:23">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3150769" xml-lang="en-US" level="1" l10n="U" oldref="1">Format Menu</paragraph>
+<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="U" oldref="2">
+<variable id="fozelle">Choose <emph>Format - Cells</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US" l10n="U" oldref="3">
+<variable id="fozelstz">Choose <emph>Format - Cells - Cell Protection</emph> tab
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="U" oldref="4">
+<variable id="fozei">Choose <emph>Format - Row</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US" l10n="U" oldref="5">
+<variable id="fozeiophoe">Choose <emph>Format - Row - Optimal Height</emph>
+</variable></paragraph>
+<section id="fozeiaus">
+<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Format - Row - Hide</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US" l10n="U" oldref="7">Choose <emph>Format - Column - Hide</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="8">Choose <emph>Format - Sheet - Hide</emph>
+</paragraph>
+</section>
+<section id="fozeiebl">
+<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="9">Choose <emph>Format - Row - Show</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US" l10n="U" oldref="10">Choose <emph>Format - Column - Show</emph>
+</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US" l10n="U" oldref="11">
+<variable id="fospa">Choose <emph>Format - Column</emph>
+</variable></paragraph>
+<section id="fospob">
+<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US" l10n="U" oldref="12">Choose <emph>Format - Column - Optimal Width</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3150716" xml-lang="en-US" l10n="U" oldref="13">On Object Bar, click</paragraph>
+<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US" l10n="U" oldref="36">Double-click right column separator in column headers</paragraph>
+<table id="tbl_id3156278" name="tbl_id3156278">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145642" xml-lang="en-US" l10n="E">
+<image id="img_id3150324" src="res/commandimagelist/sc_setoptimalcolumnwidthdirect.png" ><alt id="alt_id3150324" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US" l10n="U" oldref="15">
+<variable id="fot">Choose <emph>Format - Sheet</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US" l10n="U" oldref="16">
+<variable id="fotu">Choose <emph>Format - Sheet - Rename</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155333" xml-lang="en-US" l10n="U" oldref="17">
+<variable id="fotenb">Choose <emph>Format - Sheet - Show</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154020" xml-lang="en-US" l10n="U" oldref="18">
+<variable id="fozelzus">Choose <emph>Format - Merge Cells</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="19">
+<variable id="fozelzfe">Choose <emph>Format - Merge Cells - Define</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="20">
+<variable id="fozelzaf">Choose <emph>Format - Merge Cells - Remove</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155508" xml-lang="en-US" l10n="U" oldref="25">
+<variable id="fostel">Choose <emph>Format - Page - Sheet</emph> tab
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150883" xml-lang="en-US" l10n="U" oldref="26">
+<variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US" l10n="U" oldref="27">
+<variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156290" xml-lang="en-US" l10n="U" oldref="35">
+<variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US" l10n="U" oldref="28">
+<variable id="fodbah">Choose <emph>Format - Print Ranges - Remove</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153307" xml-lang="en-US" l10n="U" oldref="29">
+<variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph>
+</variable></paragraph>
+<section id="fovorka">
+<paragraph role="paragraph" id="par_id3159170" xml-lang="en-US" l10n="U" oldref="30">Choose <emph>Format - Style Catalog</emph>
+</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US" l10n="U" oldref="31">Choose <emph>Format - AutoFormat</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3154532" xml-lang="en-US" l10n="U" oldref="32">On the main toolbar, click</paragraph>
+<section id="syautoformat">
+<table id="tbl_id3148605" name="tbl_id3148605">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149332" xml-lang="en-US" l10n="E">
+<image id="img_id3156020" src="res/sc10242.png" ><alt id="alt_id3156020" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154060" xml-lang="en-US" l10n="U" oldref="33">AutoFormat</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="U" oldref="34">
+<variable id="bedingte">Choose <emph>Format - Conditional Formatting</emph>
+</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000406.xhp b/helpcontent2/source/text/scalc/00/00000406.xhp
new file mode 100755
index 000000000..c8b01eece
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000406.xhp
@@ -0,0 +1,101 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************--><helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000406xml" indexer="exclude" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Tools Menu</title>
+<filename>/text/scalc/00/00000406.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+
+
+ <paragraph role="heading" level="1" id="hd_id3147264" l10n="U" xml-lang="en-US" oldref="1">Tools Menu</paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3150541" xml-lang="en-US" oldref="2"><variable id="exdektv">Choose <emph>Tools - Detective</emph></variable></paragraph>
+ <section id="exdszv">
+ <paragraph l10n="U" role="paragraph" id="par_id3153194" xml-lang="en-US" oldref="3">Choose <emph>Tools - Detective - Trace Precedents</emph></paragraph>
+ <paragraph role="paragraph" id="par_id3150447" l10n="U" xml-lang="en-US" oldref="29">Shift+F7</paragraph>
+ </section>
+ <paragraph l10n="U" role="paragraph" id="par_id3154123" xml-lang="en-US" oldref="33"><variable id="silbentrennungc">Menu <emph>Tools - Hyphenation</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3145785" xml-lang="en-US" oldref="4"><variable id="exdvore">Choose <emph>Tools - Detective - Remove Precedents</emph></variable></paragraph>
+ <section id="exdsznf">
+ <paragraph l10n="U" role="paragraph" id="par_id3155411" xml-lang="en-US" oldref="5">Choose <emph>Tools - Detective - Trace Dependents</emph></paragraph>
+ <paragraph role="paragraph" id="par_id3153363" l10n="U" xml-lang="en-US" oldref="30">Shift+F5</paragraph>
+ </section>
+ <paragraph l10n="U" role="paragraph" id="par_id3146984" xml-lang="en-US" oldref="6"><variable id="exdszne">Choose <emph>Tools - Detective - Remove Dependents</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3154014" xml-lang="en-US" oldref="7"><variable id="exdase">Choose <emph>Tools - Detective - Remove All Traces</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3153188" xml-lang="en-US" oldref="8"><variable id="exdszfe">Choose <emph>Tools - Detective - Trace Error</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3149410" xml-lang="en-US" oldref="9"><variable id="fuellmodus">Choose <emph>Tools - Detective - Fill Mode</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3156284" xml-lang="en-US" oldref="10"><variable id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid Data</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3153159" xml-lang="en-US" oldref="11"><variable id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh Traces</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3147397" xml-lang="en-US" oldref="32"><variable id="automatisch">Choose <emph>Tools - Detective - AutoRefresh</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3154018" xml-lang="en-US" oldref="12"><variable id="exzws">Choose <emph>Tools - Goal Seek</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3156277" xml-lang="en-US" oldref="13"><variable id="exsze">Choose <emph>Tools - Scenarios</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3145640" xml-lang="en-US" oldref="14"><variable id="exdos">Choose <emph>Tools - Protect Document</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3149020" xml-lang="en-US" oldref="15"><variable id="exdst">Choose <emph>Tools - Protect Document - Sheet</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3154256" xml-lang="en-US" oldref="16"><variable id="exdsd">Choose <emph>Tools - Protect Document - Document</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3147363" xml-lang="en-US" oldref="17"><variable id="zellinhalte">Choose <emph>Tools - Cell Contents</emph></variable></paragraph>
+ <section id="exnb">
+ <paragraph l10n="U" role="paragraph" id="par_id3146919" xml-lang="en-US" oldref="18">Choose <emph>Tools - Cell Contents - Recalculate</emph></paragraph>
+ <paragraph role="paragraph" id="par_id3149257" l10n="U" xml-lang="en-US" oldref="31">F9</paragraph>
+ </section>
+ <paragraph l10n="U" role="paragraph" id="par_id3150941" xml-lang="en-US" oldref="19"><variable id="exatmb">Choose <emph>Tools - Cell Contents - AutoCalculate</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3151276" xml-lang="en-US" oldref="20"><variable id="autoeingabe">Choose <emph>Tools - Cell Contents - AutoInput</emph></variable></paragraph>
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000407.xhp b/helpcontent2/source/text/scalc/00/00000407.xhp
new file mode 100755
index 000000000..c517eb661
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000407.xhp
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************--><helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000407xml" indexer="exclude" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Window Menu</title>
+<filename>/text/scalc/00/00000407.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+
+
+ <paragraph role="heading" level="1" id="hd_id3155628" l10n="U" xml-lang="en-US" oldref="1">Window Menu</paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3147335" xml-lang="en-US" oldref="2"><variable id="fete">Choose <emph>Window - Split</emph></variable></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3153663" xml-lang="en-US" oldref="3"><variable id="fefix">Choose <emph>Window - Freeze</emph></variable></paragraph>
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000412.xhp b/helpcontent2/source/text/scalc/00/00000412.xhp
new file mode 100644
index 000000000..9a87be3ba
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000412.xhp
@@ -0,0 +1,246 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Data Menu</title>
+<filename>/text/scalc/00/00000412.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-07-20T10:59:33">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Menu</paragraph>
+<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US" l10n="U" oldref="3"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U" oldref="4"><variable id="dbrba">Choose <emph>Data - Select Range</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150443" xml-lang="en-US" l10n="U" oldref="5"><variable id="dnsrt">Choose <emph>Data - Sort</emph>
+</variable></paragraph>
+<section id="dnsosk">
+<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Data - Sort - Sort Criteria</emph> tab</paragraph>
+<paragraph role="paragraph" id="par_id3154516" xml-lang="en-US" l10n="U" oldref="7">On Main toolbar, click</paragraph>
+<section id="sysortieren">
+<table id="tbl_id3156023">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US" l10n="E">
+<image id="img_id3150543" src="sc/res/imglst/apptbx/sc26344.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="8">Sort Ascending</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="E">
+<image id="img_id3125863" src="sc/res/imglst/apptbx/sc26343.png" width="0.222inch" height="0.222inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="9">Sort Descending</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</section>
+<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="10"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="11"><variable id="dnftr">Choose <emph>Data - Filter</emph>
+</variable></paragraph>
+<section id="dnfiafi">
+<paragraph role="paragraph" id="par_id3148646" xml-lang="en-US" l10n="U" oldref="12">Choose <emph>Data - Filter - AutoFilter</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="U" oldref="13">On Main toolbar and Database Bar, click</paragraph>
+<section id="syautofilter">
+<table id="tbl_id3155418">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="E">
+<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>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="14">AutoFilter</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</section>
+<paragraph role="paragraph" id="par_id3156278" xml-lang="en-US" l10n="U" oldref="17"><variable id="dnfspz">Choose <emph>Data - Filter - Advanced Filter</emph>
+</variable></paragraph>
+<section id="filterzus">
+<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>
+<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>
+</section>
+<section id="dnfief">
+<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="20">Choose <emph>Data - Filter - Remove Filter</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3155961" xml-lang="en-US" l10n="U" oldref="48">On Database Bar, click <emph>Remove Filter/Sort</emph>
+</paragraph>
+<table id="tbl_id3146919">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="E">
+<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>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="49">Remove Filter/Sort</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US" l10n="U" oldref="21"><variable id="dnaftas">Choose <emph>Data - Filter - Hide AutoFilter</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3166424" xml-lang="en-US" l10n="U" oldref="22"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>
+</variable></paragraph>
+<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
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US" l10n="U" oldref="24"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145133" xml-lang="en-US" l10n="U" oldref="25"><variable id="datengueltig">Choose <emph>Data - Validity</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab
+</variable></paragraph>
+<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
+</variable></paragraph>
+<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
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="29"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="U" oldref="30"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3148701" xml-lang="en-US" l10n="U" oldref="31"><variable id="dngld">Choose <emph>Data - Outline</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US" l10n="U" oldref="32"><variable id="dngda">Choose <emph>Data - Outline - Hide Details</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3159223" xml-lang="en-US" l10n="U" oldref="33"><variable id="dngde">Choose <emph>Data - Outline - Show Details</emph>
+</variable></paragraph>
+<section id="dnglgr">
+<paragraph role="paragraph" id="par_id3146870" xml-lang="en-US" l10n="U" oldref="34">Choose <emph>Data - Outline - Group</emph>
+</paragraph>
+<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US" l10n="U" oldref="51">F12</paragraph>
+<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US" l10n="U" oldref="35">On Main toolbar, click</paragraph>
+<section id="sygruppieren">
+<table id="tbl_id3154532">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="E">
+<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>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="U" oldref="36">Insert Group</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</section>
+<section id="dnglgra">
+<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US" l10n="U" oldref="37">Choose <emph>Data - Outline - Ungroup</emph>
+</paragraph>
+<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>
+<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="U" oldref="38">On Main toolbar, click</paragraph>
+<section id="sygruppierungaufheben">
+<table id="tbl_id3143223">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="E">
+<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>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US" l10n="U" oldref="39">Ungroup</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</section>
+<paragraph role="paragraph" id="par_id3153008" xml-lang="en-US" l10n="U" oldref="40"><variable id="dnglagl">Choose <emph>Data - Outline - AutoOutline</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154709" xml-lang="en-US" l10n="U" oldref="41"><variable id="dnglef">Choose <emph>Data - Outline - Remove</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US" l10n="U" oldref="42"><variable id="dndtpt">Choose <emph>Data - DataPilot</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="U" oldref="43"><variable id="dndpa">Choose <emph>Data - DataPilot - Start</emph>
+</variable></paragraph>
+<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>.
+</variable></paragraph>
+<section id="dndpaz">
+<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>
+<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>
+</section>
+<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="U" oldref="44"><variable id="dndpak">Choose <emph>Data - DataPilot - Refresh</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="U" oldref="45"><variable id="dndploe">Choose <emph>Data - DataPilot - Delete</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150397" xml-lang="en-US" l10n="U" oldref="46"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US" l10n="NEW"><variable id="grouping">Choose <emph>Data - DataPilot - Group</emph>
+</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/makefile.mk b/helpcontent2/source/text/scalc/00/makefile.mk
new file mode 100644
index 000000000..03caccb32
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/makefile.mk
@@ -0,0 +1,47 @@
+#*************************************************************************
+#*
+#* $Workfile:$
+#*
+#* Creation date KR 28.06.99
+#* last change $Author: fpe $ $Date: 2004-08-18 10:53:55 $
+#*
+#* $Revision: 1.1 $
+#*
+#* $Logfile:$
+#*
+#* Copyright 2000 Sun Microsystems, Inc. All Rights Reserved.
+#*
+#*************************************************************************
+
+# edit to match directory level
+PRJ = ..$/..$/..$/..
+# same for all makefiles in "help2"
+PRJNAME = help2
+# edit to match the current package
+PACKAGE = text/scalc/00
+# uniqe name (module wide);
+# using a modified forme of package should do here
+TARGET = text_scalc_00
+# edit to match the current module
+MODULE = scalc
+
+# --- Settings -----------------------------------------------------
+
+.INCLUDE : $(PRJ)$/settings.pmk
+.INCLUDE : settings.mk
+
+# this list matches the *.xml files to process
+HZIPFILES = \
+ 00000004.hzip \
+ 00000402.hzip \
+ 00000403.hzip \
+ 00000404.hzip \
+ 00000405.hzip \
+ 00000406.hzip \
+ 00000407.hzip \
+ 00000412.hzip
+
+# --- Targets ------------------------------------------------------
+
+.INCLUDE : target.mk
+.INCLUDE : $(PRJ)$/makefile.pmk