summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/02
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
commited5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch)
tree7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/scalc/02
parentInitial commit. (diff)
downloadlibreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz
libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/scalc/02')
-rw-r--r--helpcontent2/source/text/scalc/02/02130000.xhp51
-rw-r--r--helpcontent2/source/text/scalc/02/02140000.xhp59
-rw-r--r--helpcontent2/source/text/scalc/02/02150000.xhp50
-rw-r--r--helpcontent2/source/text/scalc/02/02160000.xhp49
-rw-r--r--helpcontent2/source/text/scalc/02/02170000.xhp49
-rw-r--r--helpcontent2/source/text/scalc/02/06010000.xhp61
-rw-r--r--helpcontent2/source/text/scalc/02/06030000.xhp86
-rw-r--r--helpcontent2/source/text/scalc/02/06040000.xhp55
-rw-r--r--helpcontent2/source/text/scalc/02/06050000.xhp40
-rw-r--r--helpcontent2/source/text/scalc/02/06060000.xhp57
-rw-r--r--helpcontent2/source/text/scalc/02/06070000.xhp57
-rw-r--r--helpcontent2/source/text/scalc/02/06080000.xhp56
-rw-r--r--helpcontent2/source/text/scalc/02/08010000.xhp39
-rw-r--r--helpcontent2/source/text/scalc/02/08080000.xhp45
-rw-r--r--helpcontent2/source/text/scalc/02/10050000.xhp59
-rw-r--r--helpcontent2/source/text/scalc/02/10060000.xhp58
-rw-r--r--helpcontent2/source/text/scalc/02/18010000.xhp75
-rw-r--r--helpcontent2/source/text/scalc/02/18020000.xhp56
18 files changed, 1002 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 000000000..9c3cd10c7
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02130000.xhp
@@ -0,0 +1,51 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+<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>
+</history>
+</meta>
+<body>
+ <section id="currency">
+<bookmark branch="hid/.uno:NumberFormatCurrency" xml-lang="en-US" id="bm_id3148701" localize="false"/>
+<h1 id="hd_id3152892"><link href="text/scalc/02/02130000.xhp" name="Number format: Currency">Number format: Currency</link></h1>
+ <paragraph role="paragraph" id="par_id3148837" xml-lang="en-US"><ahelp hid=".uno:NumberFormatCurrency" visibility="visible">Applies the default currency format to the selected cells.</ahelp></paragraph>
+ </section>
+ <section id="sycurrency">
+ <table id="tbl_id3153915">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3155267" xml-lang="en-US"><image src="cmd/sc_currencyfield.svg" id="img_id3159096" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3159096">Currency Number Format Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Number Format: Currency</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id3146776" xml-lang="en-US"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link>.</paragraph>
+ </section>
+ </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 000000000..20cfb1bde
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02140000.xhp
@@ -0,0 +1,59 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+<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>
+</history>
+</meta>
+<body>
+<section id="percent">
+<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id3153541" localize="false"/>
+<h1 id="hd_id3156329"><link href="text/scalc/02/02140000.xhp" name="Number format: Percent">Number format: Percent</link></h1>
+<paragraph role="paragraph" id="par_id3155629" xml-lang="en-US"><ahelp hid=".uno:NumberFormatPercent">Applies the percentage format to the selected cells.</ahelp></paragraph>
+</section>
+<section id="sypercent">
+<table id="tbl_id3154758">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US">
+<image id="img_id3150869" src="cmd/sc_numberformatpercent.svg" width="1cm" height="1cm"><alt id="alt_id3150869" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">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">You can also enter a percentage sign (%) after a number in a cell:</paragraph>
+<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US">1% corresponds to 0.01</paragraph>
+<paragraph role="paragraph" id="par_id3145749" xml-lang="en-US">1 + 16% corresponds to 116% or 1.16</paragraph>
+<paragraph role="paragraph" id="par_id3148575" xml-lang="en-US">1%% corresponds to 0.0001</paragraph>
+<section id="relatedtopics">
+<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph>
+</section>
+</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 000000000..ac6bb9fda
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02150000.xhp
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+<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>
+</history>
+</meta>
+<body>
+ <section id="standard">
+<bookmark branch="hid/.uno:NumberFormatStandard" xml-lang="en-US" id="bm_id3152996" localize="false"/>
+<h1 id="hd_id3149182"><link href="text/scalc/02/02150000.xhp" name="Number format: Default">Number format: Default</link></h1>
+ <paragraph role="paragraph" id="par_id3163802" xml-lang="en-US"><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 role="paragraph" id="par_id3155922" xml-lang="en-US"><image src="cmd/sc_numberformatstandard.svg" id="img_id3156024" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3156024">Icon Standard Format </alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153361" xml-lang="en-US">Number Format: Standard</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id3154908" xml-lang="en-US"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link>.</paragraph>
+ </section></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 000000000..05622e11b
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02160000.xhp
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0202160000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">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>
+</history>
+</meta>
+<body>
+<section id="add_decimal_place"><comment>mw copied three index entries to Calc guide format_value.xhp</comment>
+<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatIncDecimals" id="bm_id1150276" localize="false"/>
+<h1 id="hd_id3150275"><link href="text/scalc/02/02160000.xhp" name="Number Format: Add Decimal Place">Number Format: Add Decimal Place</link></h1>
+<paragraph role="paragraph" id="par_id3150792" xml-lang="en-US"><ahelp hid=".uno:NumberFormatIncDecimals">Adds one decimal place to the numbers in the selected cells.</ahelp></paragraph>
+</section>
+<section id="syadd_decimal_place">
+<table id="tbl_id3156280">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US">
+<image id="img_id3145271" src="cmd/sc_numberformatincdecimals.svg" width="1cm" height="1cm"><alt id="alt_id3145271" xml-lang="en-US">Icon Add Decimal Place</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US">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 000000000..e2e2b59ee
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/02170000.xhp
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0202170000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">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>
+</history>
+</meta>
+<body>
+<section id="delete_decimal_place"><comment>mw copied three index entries to Calc guide format_value.xhp</comment>
+<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatDecDecimals" id="bm_id9660963" localize="false"/>
+<h1 id="hd_id3149164"><link href="text/scalc/02/02170000.xhp" name="Number Format: Delete Decimal Place">Number Format: Delete Decimal Place</link></h1>
+<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp hid=".uno:NumberFormatDecDecimals">Removes one decimal place from the numbers in the selected cells.</ahelp></paragraph>
+</section>
+<section id="sydelete_decimal_place">
+<table id="tbl_id3154365">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3145173" xml-lang="en-US">
+<image id="img_id3153192" src="cmd/sc_numberformatdecdecimals.svg" width="1cm" height="1cm"><alt id="alt_id3153192" xml-lang="en-US">Icon Delete Decimal Place</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3154686" xml-lang="en-US">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 000000000..9399da39c
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06010000.xhp
@@ -0,0 +1,61 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0206010000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Name Box</title>
+<filename>/text/scalc/02/06010000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+</history>
+</meta>
+<body>
+<section id="name_box">
+<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/SC_HID_INSWIN_POS" id="bm_id3153087" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:FocusCellAddress" id="bm_id2941984" localize="false"/>
+<paragraph role="heading" id="hd_id3156326" xml-lang="en-US" level="1"><link href="text/scalc/02/06010000.xhp" name="Name Box">Name Box</link></paragraph>
+<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp hid="HID_INSWIN_POS">Displays the reference for the current cell, the range of the selected cells, or the name of the area. You can also select a range of cells, and then type a name for that range into the <emph>Name Box</emph>.</ahelp><comment>UFI: fixes #i28238#</comment></paragraph>
+</section>
+<section id="syname_box">
+<table id="tbl_id3150870">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3163710" xml-lang="en-US">
+<image id="img_id3152576" src="media/helpimg/calcein.png" width="1.2398inch" height="0.2398inch" localize="true"><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">Name Box</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3152596" xml-lang="en-US">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. You can also enter full name of a sheet; the tooltip then changes to "Go To Sheet", and pressing Enter switches to that sheet.</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 000000000..cbc1f81b9
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06030000.xhp
@@ -0,0 +1,86 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+
+<meta>
+ <topic id="textscalc0206030000xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Sum</title>
+ <filename>/text/scalc/02/06030000.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="sum">
+<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 icon</bookmark_value>
+ <bookmark_value>AutoSum button, see sum icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/><comment>MW inserted a cross-reference</comment>
+<h1 id="hd_id3157909"><link href="text/scalc/02/06030000.xhp" name="Sum">Select Function</link></h1>
+ <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph"><ahelp hid="HID_INSWIN_SUMME">Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.</ahelp></paragraph>
+ </section>
+ <section id="sysum">
+ <table id="tbl_id3150868">
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph">
+<image id="img_id3147434" src="cmd/sc_autosum.svg" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3147434">Icon Select Function</alt>
+ </image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph">Select Function</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<h2 id="hd_id161592658402954">Select Function applied with no selected range</h2>
+<paragraph xml-lang="en-US" id="par_id3156444" role="paragraph">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph">Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>.</paragraph>
+<table id="tab_id891592663499228">
+ <tablerow>
+ <tablecell>
+ <paragraph role="image" id="par_id231592663499228">
+<image src="cmd/sc_ok.svg" id="img_id521592663499228" width="1cm" height="1cm"><alt id="alt_id171592663499228">Accept Icon</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481592663499228" role="paragraph">Accept</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+<table id="tab_id591592663828848">
+ <tablerow>
+ <tablecell>
+ <paragraph role="image" id="par_id311592663828848">
+<image src="cmd/sc_cancel.svg" id="img_id641592663828848" width="1cm" height="1cm"><alt id="alt_id111592663828848">Icon Cancel</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id431592663828848" role="paragraph">Cancel</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+<h2 id="hd_id261592658395518">Select Function applied on a selected range</h2>
+<paragraph role="paragraph" id="par_id911592658130888">When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column.</paragraph>
+<paragraph role="paragraph" id="par_id991592658144387">When the selected range has one row, the function result is placed in the first available cell on the right of the selected range.</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 000000000..bc96cf5f1
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06040000.xhp
@@ -0,0 +1,55 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</meta>
+<body>
+<section id="function">
+<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/SC_HID_INSWIN_FUNC" id="bm_id3145119" localize="false"/>
+<paragraph role="heading" id="hd_id3150084" xml-lang="en-US" level="1"><link href="text/scalc/02/06040000.xhp" name="Function">Function</link></paragraph>
+<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><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">This icon is only available when the <emph>Input line</emph> box is not active.</paragraph>
+<section id="syfunction">
+<table id="tbl_id3154684">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US">
+<image id="img_id3145785" src="sc/res/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">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 000000000..a9f181f43
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06050000.xhp
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="input_line">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_INPUT" id="bm_id3150084" localize="false"/>
+<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="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"><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="Function Wizard">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 000000000..a12414c27
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06060000.xhp
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="cancel">
+<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/SC_HID_INSWIN_CANCEL" id="bm_id3153088" localize="false"/>
+<paragraph role="heading" id="hd_id3154514" xml-lang="en-US" level="1"><link href="text/scalc/02/06060000.xhp" name="Cancel">Cancel</link></paragraph>
+<paragraph role="paragraph" id="par_id3153823" xml-lang="en-US"><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="sycancel">
+<table id="tbl_id3150541">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US">
+<image id="img_id3156422" src="svx/res/nu02.png" width="0.2228inch" height="0.2228inch"><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">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 000000000..fc429343f
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06070000.xhp
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="accept">
+<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/SC_HID_INSWIN_OK" id="bm_id3149164" localize="false"/>
+<paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="1"><link href="text/scalc/02/06070000.xhp" name="Accept">Accept</link></paragraph>
+<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><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="syaccept">
+<table id="tbl_id3154365">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US">
+<image id="img_id3156422" src="svx/res/nu01.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">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 000000000..651d6fdf0
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/06080000.xhp
@@ -0,0 +1,56 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0206080000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Theme Selection</title>
+<filename>/text/scalc/02/06080000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+</history>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id3147335" localize="false"/>
+<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="1"><link href="text/scalc/02/06080000.xhp" name="Theme Selection">Theme Selection</link></paragraph>
+<paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><variable id="thementext"><ahelp hid=".uno:ChooseDesign">Applies a formatting style to the selected cells.</ahelp>
+</variable> The styles include font, border, and background color information.</paragraph>
+<section id="sythemes">
+<table id="tbl_id3153968">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US">
+<image id="img_id3145785" src="cmd/sc_choosedesign.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145785" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153953" xml-lang="en-US">Choose Themes</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGSTYLES_LISTBOX" id="bm_id3153159" localize="false"/>
+<paragraph role="paragraph" id="par_id3147127" xml-lang="en-US"><ahelp 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 000000000..39b648223
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/08010000.xhp
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0208010000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Position in document</title>
+<filename>/text/scalc/02/08010000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+</history>
+</meta>
+<body>
+<section id="position_in_document">
+<bookmark xml-lang="en-US" branch="hid/.uno:StatusDocPos" id="bm_id4735827" localize="false"/>
+<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"><link href="text/scalc/02/08010000.xhp" name="Position in document">Position in document</link></paragraph>
+<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US"><ahelp hid=".uno:StatusDocPos">Displays the number of the current sheet and 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 000000000..0b73bdfac
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/08080000.xhp
@@ -0,0 +1,45 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="date_time">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>formulas;status bar</bookmark_value>
+</bookmark><comment>MW changed index entry</comment>
+<bookmark xml-lang="en-US" branch="hid/.uno:StateTableCell" id="bm_id2262199" localize="false"/>
+<paragraph role="heading" id="hd_id3147335" xml-lang="en-US" level="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"><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">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>
+<section id="relatedtopics">
+<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><link href="text/scalc/05/02140000.xhp" name="Error codes">Error codes</link></paragraph>
+</section>
+</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 000000000..a6b9f0d58
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/10050000.xhp
@@ -0,0 +1,59 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="zoom_in">
+<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>zooming;enlarging page views</bookmark_value>
+</bookmark><comment>mw deleted "scaling;"</comment>
+<bookmark xml-lang="en-US" branch="hid/.uno:ZoomIn" id="bm_id7362949" localize="false"/>
+<paragraph role="heading" id="hd_id3148491" xml-lang="en-US" level="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"><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">The maximum zoom factor is 400%.</paragraph>
+<section id="syzoom_in">
+<table id="tbl_id3154686">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US">
+<image id="img_id3151116" src="cmd/sc_zoomin.png" width="0.222inch" height="0.222inch"><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">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 000000000..2ed616c7e
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/10060000.xhp
@@ -0,0 +1,58 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="zoom_out">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3153561"><bookmark_value>page views;reducing scales</bookmark_value>
+<bookmark_value>zooming;reducing page views</bookmark_value>
+</bookmark><comment>mw deleted "scaling;"</comment>
+<bookmark xml-lang="en-US" branch="hid/.uno:ZoomOut" id="bm_id5729287" localize="false"/>
+<paragraph role="heading" id="hd_id3153561" xml-lang="en-US" level="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"><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">The minimum zoom factor is 20%.</paragraph>
+<section id="syzoom_out">
+<table id="tbl_id3125863">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US">
+<image id="img_id3155131" src="cmd/sc_zoomout.png" width="0.222inch" height="0.222inch"><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">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 000000000..f6c5fb777
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/18010000.xhp
@@ -0,0 +1,75 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+
+ <helpdocument version="1.0">
+<meta>
+<topic id="textscalc0218010000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Insert</title>
+<filename>/text/scalc/02/18010000.xhp</filename>
+</topic>
+</meta>
+<body>
+<section id="insert">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><bookmark_value>inserting; objects, toolbar icon</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertCtrl" id="bm_id5322551" localize="false"/>
+<paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1"><link href="text/scalc/02/18010000.xhp" name="Insert">Insert</link></paragraph>
+<paragraph role="paragraph" id="par_id3147336" xml-lang="en-US"><ahelp hid=".uno:InsertCtrl">Click the arrow next to the icon to open the <emph>Insert </emph>toolbar, where you can add graphics and special characters to the current sheet.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US">Tools bar icon:</paragraph>
+<section id="syinsert">
+<table id="tbl_id3154365">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">
+<image id="img_id3156423" src="cmd/sc_insertgraphic.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156423" xml-lang="en-US">Icon</alt>
+ </image></paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US">Insert</paragraph>
+</tablecell>
+</tablerow>
+</table>
+</section>
+<paragraph role="paragraph" id="par_id3153188" xml-lang="en-US">You can select the following icons:</paragraph>
+<paragraph role="heading" id="hd_id4283883" xml-lang="en-US" level="2"><link href="text/shared/01/04160500.xhp" name="Floating Frame">Floating Frame</link></paragraph>
+<embed href="text/shared/01/04160500.xhp#frameeinfuegentext"/>
+<embed href="text/shared/00/00000404.xhp#syframe"/>
+<paragraph role="heading" id="hd_id3149410" xml-lang="en-US" level="2"><link href="text/shared/01/04100000.xhp" name="Special Character">Special Character</link></paragraph>
+<embed href="text/shared/01/04100000.xhp#sonder"/>
+<embed href="text/shared/00/00000404.xhp#syspecial_char"/>
+<paragraph role="heading" id="hd_id3151117" xml-lang="en-US" level="2"><link href="text/shared/01/04140000.xhp" name="From File">From File</link></paragraph>
+<embed href="text/shared/01/04140000.xhp#grafiktext"/>
+<embed href="text/shared/00/00000404.xhp#syimage"/>
+<embed href="text/shared/01/moviesound.xhp#moviesound"/>
+<embed href="text/shared/00/00000404.xhp#symoviesound"/>
+<paragraph role="heading" id="hd_id3633533" xml-lang="en-US" level="2"><link href="text/shared/01/04160300.xhp" name="Formula">Formula</link></paragraph>
+<embed href="text/shared/01/04160300.xhp#starmath"/>
+<embed href="text/shared/00/00000404.xhp#systarmath"/>
+<paragraph role="heading" id="par_idN10769" xml-lang="en-US" level="2"><link href="text/schart/01/wiz_chart_type.xhp" name="Insert Chart">Chart</link></paragraph>
+<embed href="text/shared/00/00000404.xhp#systarchart"/>
+<paragraph role="heading" id="hd_id7581408" xml-lang="en-US" level="2"><link href="text/shared/01/04150100.xhp" name="OLE Object">OLE Object</link></paragraph>
+<embed href="text/shared/01/04150100.xhp#ole"/>
+<embed href="text/shared/00/00000404.xhp#syole"/>
+</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 000000000..c930837f1
--- /dev/null
+++ b/helpcontent2/source/text/scalc/02/18020000.xhp
@@ -0,0 +1,56 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<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>
+</history>
+</meta>
+<body>
+<section id="insert_cells">
+<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"><link href="text/scalc/02/18020000.xhp" name="Insert Cells">Insert Cells</link></paragraph>
+<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><ahelp hid=".uno:InsCellsCtrl">Click the arrow next to the icon to open the <emph>Insert Cells </emph>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">Tools bar icon:</paragraph>
+<embed href="text/scalc/00/00000404.xhp#syinsert_cells"/>
+<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">You can select the following icons:</paragraph>
+<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="2"><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#syinsert_cells_down"/>
+<paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp" name="Insert Cells Right">Insert Cells Right</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#zellenrechtstext"/>
+<embed href="text/scalc/00/00000404.xhp#syinsert_cells_right"/>
+<paragraph role="heading" id="hd_id3153190" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp" name="Rows">Rows</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#zeilenganzetext"/>
+<embed href="text/scalc/00/00000404.xhp#syinsert_rows"/>
+<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp" name="Columns">Columns</link></paragraph>
+<embed href="text/scalc/01/04020000.xhp#spaltenganzetext"/>
+<embed href="text/scalc/00/00000404.xhp#syinsert_columns"/>
+</body>
+</helpdocument>