summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/02
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/02
#i33146# Initial checkin
Diffstat (limited to 'helpcontent2/source/text/scalc/02')
-rw-r--r--helpcontent2/source/text/scalc/02/02130000.xhp93
-rw-r--r--helpcontent2/source/text/scalc/02/02140000.xhp98
-rw-r--r--helpcontent2/source/text/scalc/02/02150000.xhp93
-rw-r--r--helpcontent2/source/text/scalc/02/02160000.xhp91
-rw-r--r--helpcontent2/source/text/scalc/02/02170000.xhp91
-rw-r--r--helpcontent2/source/text/scalc/02/06010000.xhp97
-rw-r--r--helpcontent2/source/text/scalc/02/06030000.xhp97
-rw-r--r--helpcontent2/source/text/scalc/02/06040000.xhp94
-rw-r--r--helpcontent2/source/text/scalc/02/06050000.xhp76
-rw-r--r--helpcontent2/source/text/scalc/02/06060000.xhp93
-rw-r--r--helpcontent2/source/text/scalc/02/06070000.xhp93
-rw-r--r--helpcontent2/source/text/scalc/02/06080000.xhp95
-rw-r--r--helpcontent2/source/text/scalc/02/08010000.xhp74
-rw-r--r--helpcontent2/source/text/scalc/02/08080000.xhp87
-rw-r--r--helpcontent2/source/text/scalc/02/10050000.xhp96
-rw-r--r--helpcontent2/source/text/scalc/02/10060000.xhp95
-rw-r--r--helpcontent2/source/text/scalc/02/18010000.xhp100
-rw-r--r--helpcontent2/source/text/scalc/02/18020000.xhp93
-rw-r--r--helpcontent2/source/text/scalc/02/makefile.mk57
19 files changed, 1713 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/02/02130000.xhp b/helpcontent2/source/text/scalc/02/02130000.xhp
new file mode 100644
index 0000000000..83a671da2f
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02130000.xhp
@@ -0,0 +1,93 @@
+<?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="textscalc0202130000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Number format: Currency</title>
+<filename>/text/scalc/02/02130000.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>
+
+
+ <section id="waehrung">
+ <bookmark branch="hid/.uno:NumberFormatCurrency" xml-lang="en-US" id="bm_id3148701"/><paragraph id="hd_id3152892" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/02130000.xhp" name="Number format: Currency">Number format: Currency</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3148837" xml-lang="en-US" oldref="2"><ahelp hid=".uno:NumberFormatCurrency" visibility="visible">Applies the default currency format to the selected cells.</ahelp></paragraph>
+ </section>
+ <section id="sywaehrung">
+ <table id="tbl_id3153915">
+
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph l10n="E" role="paragraph" id="par_id3155267" xml-lang="en-US" oldref=""><image src="res/sc10707.png" id="img_id3159096"><alt xml-lang="en-US" id="alt_id3159096">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150214" l10n="U" xml-lang="en-US" oldref="3">Number Format: Currency</paragraph>
+ </tablecell>
+ </tablerow>
+
+ </table>
+ </section>
+ <embed href="text/shared/00/00000004.xhp#related"/>
+ <paragraph l10n="U" role="paragraph" id="par_id3146776" xml-lang="en-US" oldref="4"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link>.</paragraph>
+
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/02140000.xhp b/helpcontent2/source/text/scalc/02/02140000.xhp
new file mode 100644
index 0000000000..1273c28011
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02140000.xhp
@@ -0,0 +1,98 @@
+<?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="textscalc0202140000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Number format: Percent</title>
+<filename>/text/scalc/02/02140000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-16T11:38:54">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="prozent">
+<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id3153541" localize="false"/>
+<paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/02140000.xhp" name="Number format: Percent">Number format: Percent</link></paragraph>
+<paragraph role="paragraph" id="par_id3155629" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:NumberFormatPercent">Applies the percentage format to the selected cells.</ahelp></paragraph>
+</section>
+<section id="syprozent">
+<table id="tbl_id3154758">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US" l10n="E">
+<image id="img_id3150869" src="sc/res/imglst/apptbx/sc26046.png" width="5.64mm" height="5.64mm"><alt id="alt_id3150869" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="3">Number Format: Percent</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149260"><bookmark_value>percentage calculations</bookmark_value>
+</bookmark>
+<paragraph role="paragraph" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="5">You can also enter a percentage sign (%) after a number in a cell:</paragraph>
+<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U" oldref="6">1% corresponds to 0.01</paragraph>
+<paragraph role="paragraph" id="par_id3145749" xml-lang="en-US" l10n="U" oldref="7">1 + 16% corresponds to 116% or 1.16</paragraph>
+<paragraph role="paragraph" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="8">1%% corresponds to 0.0001</paragraph>
+<embed href="text/shared/00/00000004.xhp#related"/>
+<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US" l10n="U" oldref="10"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/02150000.xhp b/helpcontent2/source/text/scalc/02/02150000.xhp
new file mode 100644
index 0000000000..c4cd1cf0cc
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02150000.xhp
@@ -0,0 +1,93 @@
+<?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="textscalc0202150000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Number format: Default</title>
+<filename>/text/scalc/02/02150000.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>
+
+
+ <section id="standard">
+ <bookmark branch="hid/.uno:NumberFormatStandard" xml-lang="en-US" id="bm_id3152996"/><paragraph id="hd_id3149182" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/02150000.xhp" name="Number format: Default">Number format: Default</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3163802" xml-lang="en-US" oldref="2"><ahelp hid=".uno:NumberFormatStandard" visibility="visible">Applies the default number format to the selected cells.</ahelp></paragraph>
+ </section>
+ <section id="systandard">
+ <table id="tbl_id3156326">
+
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph l10n="E" role="paragraph" id="par_id3155922" xml-lang="en-US" oldref=""><image src="res/commandimagelist/sc_numberformatstandard.png" id="img_id3156024"><alt xml-lang="en-US" id="alt_id3156024">Icon</alt></image></paragraph>
+
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153361" l10n="U" xml-lang="en-US" oldref="3">Number Format: Standard</paragraph>
+ </tablecell>
+ </tablerow>
+
+ </table>
+ </section>
+ <embed href="text/shared/00/00000004.xhp#related"/>
+ <paragraph l10n="U" role="paragraph" id="par_id3154908" xml-lang="en-US" oldref="4"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link>.</paragraph>
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/02160000.xhp b/helpcontent2/source/text/scalc/02/02160000.xhp
new file mode 100644
index 0000000000..ce32d984e4
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02160000.xhp
@@ -0,0 +1,91 @@
+<?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="textscalc0202160000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Number Format: Add Decimal Place</title>
+<filename>/text/scalc/02/02160000.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>
+
+
+ <section id="dezimalhin">
+ <bookmark branch="index" xml-lang="en-US" id="bm_id3150275"><bookmark_value>formatting;adding decimal places</bookmark_value><bookmark_value>number formats; adding decimal places</bookmark_value><bookmark_value>decimal places; adding</bookmark_value></bookmark><bookmark branch="hid/.uno:NumberFormatIncDecimals" xml-lang="en-US" id="bm_id3155922"/><paragraph id="hd_id3150275" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/02160000.xhp" name="Number Format: Add Decimal Place">Number Format: Add Decimal Place</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3150792" xml-lang="en-US" oldref="2"><ahelp hid=".uno:NumberFormatIncDecimals" visibility="visible">Adds one decimal place to the numbers in the selected cells.</ahelp></paragraph>
+ </section>
+ <section id="sydezimalhin">
+ <table id="tbl_id3156280">
+
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph l10n="E" role="paragraph" id="par_id3145787" xml-lang="en-US" oldref=""><image src="res/commandimagelist/sc_numberformatincdecimals.png" id="img_id3145271"><alt xml-lang="en-US" id="alt_id3145271">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149262" l10n="U" xml-lang="en-US" oldref="3">Number Format: Add Decimal Place</paragraph>
+ </tablecell>
+ </tablerow>
+
+ </table>
+ </section>
+
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/02170000.xhp b/helpcontent2/source/text/scalc/02/02170000.xhp
new file mode 100644
index 0000000000..6dff177639
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02170000.xhp
@@ -0,0 +1,91 @@
+<?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="textscalc0202170000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Number Format: Delete Decimal Place</title>
+<filename>/text/scalc/02/02170000.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>
+
+
+ <section id="dezimalweg">
+ <bookmark branch="index" xml-lang="en-US" id="bm_id3149164"><bookmark_value>formatting;deleting decimal places</bookmark_value><bookmark_value>number formats; deleting decimal places</bookmark_value><bookmark_value>deleting; decimal places</bookmark_value></bookmark><bookmark branch="hid/.uno:NumberFormatDecDecimals" xml-lang="en-US" id="bm_id3153252"/><paragraph id="hd_id3149164" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/02170000.xhp" name="Number Format: Delete Decimal Place">Number Format: Delete Decimal Place</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3147264" xml-lang="en-US" oldref="2"><ahelp hid=".uno:NumberFormatDecDecimals" visibility="visible">Removes one decimal place from the numbers in the selected cells.</ahelp></paragraph>
+ </section>
+ <section id="sydezimalweg">
+ <table id="tbl_id3154365">
+
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph l10n="E" role="paragraph" id="par_id3145173" xml-lang="en-US" oldref=""><image src="res/commandimagelist/sc_numberformatdecdecimals.png" id="img_id3153192"><alt xml-lang="en-US" id="alt_id3153192">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3154686" l10n="U" xml-lang="en-US" oldref="3">Number Format: Delete Decimal Place</paragraph>
+ </tablecell>
+ </tablerow>
+
+ </table>
+ </section>
+
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06010000.xhp b/helpcontent2/source/text/scalc/02/06010000.xhp
new file mode 100644
index 0000000000..9329b318c3
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06010000.xhp
@@ -0,0 +1,97 @@
+<?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="textscalc0206010000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Sheet Area</title>
+<filename>/text/scalc/02/06010000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T09:56:38">UFI: fixed #i28238# and "sc-features Create named ranges by typing into the name box"
+dedr: reviewed</lastedited>
+</history>
+</meta>
+<body>
+<section id="tabellenbereich">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3156326"><bookmark_value>formula bar; sheet area names</bookmark_value>
+<bookmark_value>sheet area names</bookmark_value>
+<bookmark_value>showing; cell references</bookmark_value>
+<bookmark_value>cell references; showing</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_POS" id="bm_id3153087" localize="false"/>
+<paragraph role="heading" id="hd_id3156326" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/scalc/02/06010000.xhp" name="Sheet Area">Name Box</link></paragraph>
+<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_POS">Displays the reference for the current cell, the range of the selected cells, or the name of the area.</ahelp> You can also select a range of cells, and then type a name for that range into the <emph>Name Box</emph>.<comment>UFI: fixes #i28238#</comment></paragraph>
+</section>
+<section id="sytabellenbereich">
+<table id="tbl_id3150870">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3163710" xml-lang="en-US" l10n="E">
+<image id="img_id3152576" src="res/helpimg/calcein.png" width="31.49mm" height="6.09mm"><alt id="alt_id3152576" xml-lang="en-US">Combo box sheet area</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3151118" xml-lang="en-US" l10n="CHG" oldref="4">Name Box</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3152596" xml-lang="en-US" l10n="U" oldref="6">To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4.</paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06030000.xhp b/helpcontent2/source/text/scalc/02/06030000.xhp
new file mode 100644
index 0000000000..f874f78a4a
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06030000.xhp
@@ -0,0 +1,97 @@
+<?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="textscalc0206030000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Sum</title>
+<filename>/text/scalc/02/06030000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-16T13:07:32">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="summe">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3157909"><bookmark_value>functions;sum function icon</bookmark_value>
+<bookmark_value>formula bar;sum function</bookmark_value>
+<bookmark_value>sum function in formula bar</bookmark_value>
+<bookmark_value>adding; sum icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/>
+<paragraph role="heading" id="hd_id3157909" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph>
+<paragraph role="paragraph" id="par_id3150543" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_SUMME">Automatically adds the numbers in the cell range that you specify. Click in a cell, click this icon, and then enter the cell range. You can also drag to define a cell range in the spreadsheet.</ahelp></paragraph>
+</section>
+<section id="sysumme">
+<table id="tbl_id3150868">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="E">
+<image id="img_id3147434" src="res/commandimagelist/sc_autosum.png" width="5.64mm" height="5.64mm"><alt id="alt_id3147434" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3152577" xml-lang="en-US" l10n="U" oldref="15">Sum</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US" l10n="U" oldref="16">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function.</paragraph>
+<paragraph role="paragraph" id="par_id3153189" xml-lang="en-US" l10n="U" oldref="3">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06040000.xhp b/helpcontent2/source/text/scalc/02/06040000.xhp
new file mode 100644
index 0000000000..058a93a3cd
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06040000.xhp
@@ -0,0 +1,94 @@
+<?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="textscalc0206040000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Function</title>
+<filename>/text/scalc/02/06040000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T11:09:26">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="funktion">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150084"><bookmark_value>formula bar; functions</bookmark_value>
+<bookmark_value>functions; formula bar icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_FUNC" id="bm_id3145119" localize="false"/>
+<paragraph role="heading" id="hd_id3150084" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06040000.xhp" name="Function">Function</link></paragraph>
+<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_FUNC">Adds a formula to the current cell. Click this icon, and then enter the formula in the <emph>Input line</emph>.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3153360" xml-lang="en-US" l10n="U" oldref="3">This icon is only available when the <emph>Input line</emph> box is hidden.</paragraph>
+<section id="syfunktion">
+<table id="tbl_id3154684">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="E">
+<image id="img_id3145785" src="sc/res/imglst/apptbx/sc26049.png" width="5.64mm" height="5.64mm"><alt id="alt_id3145785" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153951" xml-lang="en-US" l10n="U" oldref="4">Function</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06050000.xhp b/helpcontent2/source/text/scalc/02/06050000.xhp
new file mode 100644
index 0000000000..e3d9d4af37
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06050000.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="textscalc0206050000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Input line</title>
+<filename>/text/scalc/02/06050000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-07-16T13:02:48">FPE: Deleted screenshot</lastedited>
+</history>
+</meta>
+<body>
+<section id="eingabezeile">
+<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_INPUT" id="bm_id3150084" localize="false"/>
+<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06050000.xhp" name="Input line">Input line</link></paragraph>
+<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_INPUT">Enter the formula that you want to add to the current cell. You can also click the <link href="text/scalc/01/04060000.xhp" name="AutoPilot: Functions">Function Wizard</link> icon to insert a predefined function into the formula.</ahelp></paragraph>
+</section>
+<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06060000.xhp b/helpcontent2/source/text/scalc/02/06060000.xhp
new file mode 100644
index 0000000000..937a1fdcb7
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06060000.xhp
@@ -0,0 +1,93 @@
+<?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="textscalc0206060000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Cancel</title>
+<filename>/text/scalc/02/06060000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T11:09:02">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="verwerfen">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3154514"><bookmark_value>formula bar; canceling inputs</bookmark_value>
+<bookmark_value>functions; canceling input icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_CANCEL" id="bm_id3153088" localize="false"/>
+<paragraph role="heading" id="hd_id3154514" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06060000.xhp" name="Cancel">Cancel</link></paragraph>
+<paragraph role="paragraph" id="par_id3153823" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_CANCEL">Clears the contents of the <emph>Input line</emph>, or cancels the changes that you made to an existing formula.</ahelp></paragraph>
+</section>
+<section id="syverwerfen">
+<table id="tbl_id3150541">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US" l10n="E">
+<image id="img_id3156422" src="sw/res/sc20557.png" width="5.66mm" height="5.66mm"><alt id="alt_id3156422" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153970" xml-lang="en-US" l10n="U" oldref="3">Cancel</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06070000.xhp b/helpcontent2/source/text/scalc/02/06070000.xhp
new file mode 100644
index 0000000000..0212bd8895
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06070000.xhp
@@ -0,0 +1,93 @@
+<?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="textscalc0206070000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Accept</title>
+<filename>/text/scalc/02/06070000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T11:08:35">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="uebernehmen">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3143267"><bookmark_value>formula bar; accepting inputs</bookmark_value>
+<bookmark_value>functions; accepting input icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_OK" id="bm_id3149164" localize="false"/>
+<paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06070000.xhp" name="Accept">Accept</link></paragraph>
+<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_OK">Accepts the contents of the <emph>Input line</emph>, and then inserts the contents into the current cell.</ahelp></paragraph>
+</section>
+<section id="syuebernehmen">
+<table id="tbl_id3154365">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US" l10n="E">
+<image id="img_id3156422" src="svx/res/nu07.png" width="5.64mm" height="5.64mm"><alt id="alt_id3156422" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US" l10n="U" oldref="3">Accept</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/06080000.xhp b/helpcontent2/source/text/scalc/02/06080000.xhp
new file mode 100644
index 0000000000..017f01b06e
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06080000.xhp
@@ -0,0 +1,95 @@
+<?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="textscalc0206080000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Theme Selection</title>
+<filename>/text/scalc/02/06080000.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>
+
+
+ <bookmark branch="hid/.uno:ChooseDesign" xml-lang="en-US" id="bm_id3147335"/><paragraph id="hd_id3153087" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/06080000.xhp" name="Theme Selection">Theme Selection</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3154515" xml-lang="en-US" oldref="2"><variable id="thementext"><ahelp hid=".uno:ChooseDesign" visibility="visible">Applies a formatting style to the selected cells.</ahelp></variable> The styles include font, border, and background color information.</paragraph>
+ <paragraph xml-lang="en-US" oldref="3" l10n="U" role="paragraph" id="par_id3154760">To open the <emph>Choose Themes</emph> dialog, click the <emph>Theme Selection </emph>icon on the <emph>Main Toolbar</emph>.</paragraph>
+ <section id="sythemen">
+ <table id="tbl_id3153968">
+
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph l10n="E" role="paragraph" id="par_id3155132" xml-lang="en-US" oldref=""><image src="res/commandimagelist/sc_choosedesign.png" id="img_id3145785"><alt xml-lang="en-US" id="alt_id3145785">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153953" l10n="U" xml-lang="en-US" oldref="4">Choose Themes</paragraph>
+ </tablecell>
+ </tablerow>
+
+ </table>
+ </section>
+ <paragraph xml-lang="en-US" role="note" id="par_id3154942" l10n="U" oldref="7">When you click the <emph>Choose Themes </emph>icon, $[officename] automatically saves a copy of the spreadsheet.</paragraph>
+ <bookmark branch="hid/HID_DLGSTYLES_LISTBOX" xml-lang="en-US" id="bm_id3153159"/><paragraph l10n="U" role="paragraph" id="par_id3147127" xml-lang="en-US" oldref="5"><ahelp visibility="visible" hid="HID_DLGSTYLES_LISTBOX">Click the formatting theme that you want to apply, and then click <emph>OK</emph>.</ahelp></paragraph>
+ <embed href="text/scalc/guide/design.xhp#design"/>
+
+
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/08010000.xhp b/helpcontent2/source/text/scalc/02/08010000.xhp
new file mode 100644
index 0000000000..5fa5cfed85
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/08010000.xhp
@@ -0,0 +1,74 @@
+<?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="textscalc0208010000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Position in document</title>
+<filename>/text/scalc/02/08010000.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>
+
+
+ <section id="positionimdokument">
+ <bookmark branch="hid/.uno:StatusDocPos" xml-lang="en-US" id="bm_id3151245"/><paragraph id="hd_id3145119" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/08010000.xhp" name="Position in document">Position in document</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3147265" xml-lang="en-US" oldref="2"><ahelp hid=".uno:StatusDocPos" visibility="visible">Displays the total number of the current sheet with respect to the total number of sheets in the spreadsheet.</ahelp></paragraph>
+ </section>
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/08080000.xhp b/helpcontent2/source/text/scalc/02/08080000.xhp
new file mode 100644
index 0000000000..6ff54ee61f
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/08080000.xhp
@@ -0,0 +1,87 @@
+<?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="textscalc0208080000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Standard Formula, Date/Time, Error Warning</title>
+<filename>/text/scalc/02/08080000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T10:54:11">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="datumzeit">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>status bar info</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_NONE" id="bm_id3156327" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_SUM" id="bm_id3143267" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_MIN" id="bm_id3154514" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_MAX" id="bm_id3150275" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_COUNT" id="bm_id3153087" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_COUNT2" id="bm_id3151245" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/HID_MNU_FUNC_AVG" id="bm_id3156024" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:StateTableCell" id="bm_id3151384" localize="false"/>
+<paragraph role="heading" id="hd_id3147335" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/08080000.xhp" name="Standard Formula, Date/Time, Error Warning">Standard Formula, Date/Time, Error Warning</link></paragraph>
+<paragraph role="paragraph" id="par_id3150791" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:StateTableCell">Displays information about the current document. By default, the SUM of the contents of the selected cells is displayed.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3155061" xml-lang="en-US" l10n="U" oldref="3">To change the default formula that is displayed, right-click the field, and then choose the formula that you want. The available formulas are: Average, count of values (COUNTA), count of numbers (COUNT), Maximum, Minimum, Sum, or None.</paragraph>
+<embed href="text/shared/00/00000004.xhp#related"/>
+<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U" oldref="4"><link href="text/scalc/05/02140000.xhp" name="Error codes">Error codes</link></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/10050000.xhp b/helpcontent2/source/text/scalc/02/10050000.xhp
new file mode 100644
index 0000000000..3e216bc55f
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/10050000.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="textscalc0210050000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Zoom In</title>
+<filename>/text/scalc/02/10050000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T11:29:52">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="massstabvergroessern">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148491"><bookmark_value>page views; increasing scales</bookmark_value>
+<bookmark_value>increasing scales in page view</bookmark_value>
+<bookmark_value>scaling;page views</bookmark_value>
+<bookmark_value>zooming;page views</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/.uno:ZoomIn" id="bm_id3143267" localize="false"/>
+<paragraph role="heading" id="hd_id3148491" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/10050000.xhp" name="Zoom In">Zoom In</link></paragraph>
+<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:ZoomIn">Enlarges the screen display of the current document. The current zoom factor is displayed on the <emph>Status Bar</emph>.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="U" oldref="4">The maximum zoom factor is 400%.</paragraph>
+<section id="sygross">
+<table id="tbl_id3154686">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="E">
+<image id="img_id3151116" src="res/commandimagelist/sc_helpzoomin.png" width="5.64mm" height="5.64mm"><alt id="alt_id3151116" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="U" oldref="3">Zoom In</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/10060000.xhp b/helpcontent2/source/text/scalc/02/10060000.xhp
new file mode 100644
index 0000000000..28d7db463b
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/10060000.xhp
@@ -0,0 +1,95 @@
+<?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="textscalc0210060000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Zoom Out</title>
+<filename>/text/scalc/02/10060000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-16T13:30:50">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="massstabverkleinern">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3153561"><bookmark_value>page views;reducing scale</bookmark_value>
+<bookmark_value>scaling; reducing the screen display</bookmark_value>
+<bookmark_value>zooming;reducing page views</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/.uno:ZoomOut" id="bm_id3156329" localize="false"/>
+<paragraph role="heading" id="hd_id3153561" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/10060000.xhp" name="Zoom Out">Zoom Out</link></paragraph>
+<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:ZoomOut">Reduces the screen display of the current document. The current zoom factor is displayed on the <emph>Status Bar</emph>.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="U" oldref="4">The minimum zoom factor is 20%.</paragraph>
+<section id="syklein">
+<table id="tbl_id3125863">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="E">
+<image id="img_id3155131" src="res/sc10098.png" width="5.64mm" height="5.64mm"><alt id="alt_id3155131" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US" l10n="U" oldref="3">Zooming Out</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/18010000.xhp b/helpcontent2/source/text/scalc/02/18010000.xhp
new file mode 100644
index 0000000000..75c7350882
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/18010000.xhp
@@ -0,0 +1,100 @@
+<?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="textscalc0218010000xml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Insert</title>
+<filename>/text/scalc/02/18010000.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>
+
+
+ <section id="einfuegen">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><bookmark_value>inserting; objects, toolbar icon</bookmark_value></bookmark><bookmark branch="hid/.uno:InsertCtrl" xml-lang="en-US" id="bm_id3156327"/><paragraph id="hd_id3156329" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/18010000.xhp" name="Insert">Insert</link></paragraph>
+ <paragraph l10n="U" role="paragraph" id="par_id3147336" xml-lang="en-US" oldref="2"><ahelp visibility="visible" hid=".uno:InsertCtrl">Long-click to open the <emph>Insert </emph>floating toolbar, where you can add graphics and special characters to the current sheet.</ahelp></paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id3148664" l10n="U" xml-lang="en-US" oldref="3">Main Toolbar icon:</paragraph>
+ <section id="syeinfuegen">
+ <table id="tbl_id3154365">
+
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph l10n="E" role="paragraph" id="par_id3150767" xml-lang="en-US" oldref=""><image src="res/commandimagelist/sc_objectcatalog.png" id="img_id3156423"><alt xml-lang="en-US" id="alt_id3156423">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3146120" l10n="U" xml-lang="en-US" oldref="4">Insert</paragraph>
+ </tablecell>
+ </tablerow>
+
+ </table>
+ </section>
+ <paragraph xml-lang="en-US" oldref="5" role="paragraph" id="par_id3145364" l10n="U">The <emph>Insert </emph>icon on the <emph>Main Toolbar</emph> displays the icon of the last used command.</paragraph>
+ <paragraph role="paragraph" id="par_id3153188" l10n="U" xml-lang="en-US" oldref="6">You can select the following icons:</paragraph>
+ <paragraph id="hd_id3151117" role="heading" level="2" oldref="7" l10n="U" xml-lang="en-US"><link href="text/shared/01/04140000.xhp" name="Insert Graphics">Insert Graphics</link></paragraph>
+ <embed href="text/shared/01/04140000.xhp#grafiktext"/>
+ <embed href="text/shared/00/00000404.xhp#sygrafik"/>
+ <paragraph id="hd_id3149410" role="heading" level="2" oldref="8" l10n="U" xml-lang="en-US"><link href="text/shared/01/04100000.xhp" name="Insert Special Character">Insert Special Character</link></paragraph>
+ <embed href="text/shared/01/04100000.xhp#sonder"/>
+ <embed href="text/shared/00/00000404.xhp#sysonder"/>
+
+ </body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/18020000.xhp b/helpcontent2/source/text/scalc/02/18020000.xhp
new file mode 100644
index 0000000000..20a2900157
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/18020000.xhp
@@ -0,0 +1,93 @@
+<?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="textscalc0218020000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Insert Cells</title>
+<filename>/text/scalc/02/18020000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T11:34:24">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<section id="zelleneinfuegen">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150275"><bookmark_value>inserting; cells, toolbar icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsCellsCtrl" id="bm_id3156329" localize="false"/>
+<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/18020000.xhp" name="Insert Cells">Insert Cells</link></paragraph>
+<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:InsCellsCtrl">Long-click to open the <emph>Insert Cells </emph>floating toolbar, where you can insert cells, rows, and columns into the current sheet.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="U" oldref="3">Main Toolbar icon:</paragraph>
+<embed href="text/scalc/00/00000404.xhp#syzelleneinfuegen"/>
+<paragraph role="paragraph" id="par_id3154910" xml-lang="en-US" l10n="U" oldref="4">The <emph>Insert </emph>icon on the <emph>Main Toolbar</emph> displays the icon of the last used command.</paragraph>
+<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="5">You can select the following icons:</paragraph>
+<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="2" l10n="U" oldref="6"><link href="text/scalc/01/04020000.xhp" name="Insert Cells Down">Insert Cells Down</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#zellenuntentext"/>
+<embed href="text/scalc/00/00000404.xhp#syzellenunten"/>
+<paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="2" l10n="U" oldref="7"><link href="text/scalc/01/04020000.xhp" name="Insert Cell Right">Insert Cell Right</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#zellenrechtstext"/>
+<embed href="text/scalc/00/00000404.xhp#syzellenrechts"/>
+<paragraph role="heading" id="hd_id3153190" xml-lang="en-US" level="2" l10n="U" oldref="8"><link href="text/scalc/01/04020000.xhp" name="Insert Rows">Insert Rows</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#zeilenganzetext"/>
+<embed href="text/scalc/00/00000404.xhp#syzeilenganze"/>
+<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="2" l10n="U" oldref="9"><link href="text/scalc/01/04020000.xhp" name="Insert Columns">Insert Columns</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#spaltenganzetext"/>
+<embed href="text/scalc/00/00000404.xhp#syspaltenganze"/>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/02/makefile.mk b/helpcontent2/source/text/scalc/02/makefile.mk
new file mode 100644
index 0000000000..5682adfff5
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/makefile.mk
@@ -0,0 +1,57 @@
+#*************************************************************************
+#*
+#* $Workfile:$
+#*
+#* Creation date KR 28.06.99
+#* last change $Author: fpe $ $Date: 2004-08-18 10:54:28 $
+#*
+#* $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/02
+# uniqe name (module wide);
+# using a modified forme of package should do here
+TARGET = text_scalc_02
+# 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 = \
+ 02130000.hzip \
+ 02140000.hzip \
+ 02150000.hzip \
+ 02160000.hzip \
+ 02170000.hzip \
+ 06010000.hzip \
+ 06030000.hzip \
+ 06040000.hzip \
+ 06050000.hzip \
+ 06060000.hzip \
+ 06070000.hzip \
+ 06080000.hzip \
+ 08010000.hzip \
+ 08080000.hzip \
+ 10050000.hzip \
+ 10060000.hzip \
+ 18010000.hzip \
+ 18020000.hzip
+
+# --- Targets ------------------------------------------------------
+
+.INCLUDE : target.mk
+.INCLUDE : $(PRJ)$/makefile.pmk