summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/00
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/00')
-rw-r--r--helpcontent2/source/text/scalc/00/00000004.xhp33
-rw-r--r--helpcontent2/source/text/scalc/00/00000402.xhp55
-rw-r--r--helpcontent2/source/text/scalc/00/00000403.xhp34
-rw-r--r--helpcontent2/source/text/scalc/00/00000404.xhp162
-rw-r--r--helpcontent2/source/text/scalc/00/00000405.xhp79
-rw-r--r--helpcontent2/source/text/scalc/00/00000406.xhp66
-rw-r--r--helpcontent2/source/text/scalc/00/00000407.xhp32
-rw-r--r--helpcontent2/source/text/scalc/00/00000412.xhp172
-rw-r--r--helpcontent2/source/text/scalc/00/avail_release.xhp81
-rw-r--r--helpcontent2/source/text/scalc/00/sheet_menu.xhp40
10 files changed, 754 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/00/00000004.xhp b/helpcontent2/source/text/scalc/00/00000004.xhp
new file mode 100644
index 000000000..640164de3
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000004.xhp
@@ -0,0 +1,33 @@
+<?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="textscalc0000000004xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">To access this function...</title>
+ <filename>/text/scalc/00/00000004.xhp</filename>
+ </topic>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="1"><variable id="wie">To access this function...</variable></paragraph>
+<paragraph role="paragraph" id="par_idN1056E" xml-lang="en-US"><variable id="moreontop">More explanations on top of this page.</variable></paragraph>
+<paragraph role="note" id="par_idN105AF" xml-lang="en-US"><variable id="optional">In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.</variable><comment>UFI: see #i43239# and #i3879#</comment></paragraph>
+<paragraph role="paragraph" id="par_id9751884" xml-lang="en-US"><variable id="codes">Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000402.xhp b/helpcontent2/source/text/scalc/00/00000402.xhp
new file mode 100644
index 000000000..bf8ddefe9
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000402.xhp
@@ -0,0 +1,55 @@
+<?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="textscalc0000000402xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Edit Menu</title>
+ <filename>/text/scalc/00/00000402.xhp</filename>
+ </topic>
+</meta>
+<body>
+<paragraph id="hd_id3147303" role="heading" level="1" xml-lang="en-US">Edit Menu</paragraph>
+<paragraph id="par_id3155555" role="paragraph" xml-lang="en-US"><variable id="kopffuss">Choose <emph>Insert - Headers and Footers</emph>.</variable></paragraph>
+<paragraph id="par_id3159233" role="paragraph" xml-lang="en-US"><variable id="bkopfzeile">Choose <emph>Insert - Headers and Footers - Header and Footer</emph> tabs.</variable></paragraph>
+<paragraph id="par_id3150443" role="paragraph" xml-lang="en-US"><variable id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph>
+<paragraph id="par_id3143267" role="paragraph" xml-lang="en-US"><variable id="bausunten">Choose <emph>Sheet - Fill Cells - Down</emph>.</variable></paragraph>
+<paragraph id="par_id3153880" role="paragraph" xml-lang="en-US"><variable id="bausrechts">Choose <emph>Sheet - Fill Cells - Right</emph>.</variable></paragraph>
+<paragraph id="par_id3151245" role="paragraph" xml-lang="en-US"><variable id="bausoben">Choose <emph>Sheet - Fill Cells - Up</emph>.</variable></paragraph>
+<paragraph id="par_id3145068" role="paragraph" xml-lang="en-US"><variable id="bauslinks">Choose <emph>Sheet - Fill Cells - Left</emph>.</variable></paragraph>
+<paragraph id="par_id3150400" role="paragraph" xml-lang="en-US"><variable id="baustab">Choose <emph>Sheet - Fill Cells - Sheets</emph>.</variable></paragraph>
+<paragraph id="par_id3154910" role="paragraph" xml-lang="en-US"><variable id="bausreihe">Choose <emph>Sheet - Fill Cells - Series</emph>.</variable></paragraph>
+
+<section id="binhalt">
+<paragraph id="par_id3154123" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Clear Cells</emph>.</paragraph>
+<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US">Backspace</paragraph>
+</section>
+<paragraph id="par_id3150011" role="paragraph" xml-lang="en-US"><variable id="bzelo">Choose <emph>Sheet - Delete Cells</emph>.</variable></paragraph>
+
+<section id="btaloes">
+<paragraph id="par_id3153951" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Delete Sheet</emph>.</paragraph>
+<paragraph id="par_id3155306" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph>
+</section>
+
+<section id="btaverko">
+<paragraph id="par_id3146119" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Move or Copy Sheet</emph>.</paragraph>
+<paragraph id="par_id3148645" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000403.xhp b/helpcontent2/source/text/scalc/00/00000403.xhp
new file mode 100644
index 000000000..8ae11a39b
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000403.xhp
@@ -0,0 +1,34 @@
+<?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="textscalc0000000403xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">View Menu</title>
+ <filename>/text/scalc/00/00000403.xhp</filename>
+ </topic>
+</meta>
+<body>
+<paragraph id="hd_id3145673" role="heading" level="1" xml-lang="en-US">View Menu</paragraph>
+<paragraph id="par_id3150275" role="paragraph" xml-lang="en-US"><variable id="aspze">Choose <emph>View - Column &amp; Row Headers</emph>.</variable></paragraph>
+<paragraph id="par_id3154514" role="paragraph" xml-lang="en-US"><variable id="awehe">Choose <emph>View - Value Highlighting</emph>.</variable></paragraph>
+<paragraph id="par_id3148947" role="paragraph" xml-lang="en-US"><variable id="rechenleiste">Choose <emph>View - Formula Bar</emph> or <emph>View - Toolbars - Formula Bar</emph>.</variable></paragraph>
+<paragraph id="par_id3148663" role="paragraph" xml-lang="en-US"><variable id="seumvo">Choose <emph>View - Page Break</emph>.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000404.xhp b/helpcontent2/source/text/scalc/00/00000404.xhp
new file mode 100644
index 000000000..495c4cffe
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000404.xhp
@@ -0,0 +1,162 @@
+<?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="textscalc0000000404xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Insert Menu</title>
+ <filename>/text/scalc/00/00000404.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
+</meta>
+<body>
+<h1 id="hd_id3149346">Insert Menu</h1>
+<section id="eize">
+<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US">Choose <menuitem>Sheet - Insert Cells</menuitem>.</paragraph>
+<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US">Choose <menuitem>View - Toolbars</menuitem> and select the <emph>Insert Cells</emph> toolbar:</paragraph>
+<section id="syzelleneinfuegen">
+<table id="tbl_id3148550">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US">
+<image id="img_id3154365" src="cmd/sc_inscellsctrl.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154365" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US">Insert Cells</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</section>
+<section id="syzellenunten">
+<table id="tbl_id3159486">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US">
+<image id="img_id3145364" src="cmd/sc_insertcellsdown.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145364" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US">Insert Cells Down</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syzellenrechts">
+<table id="tbl_id3148575">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US">
+<image id="img_id3154942" src="cmd/sc_insertcellsright.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154942" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US">Insert Cells Right</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syzeilenganze">
+<table id="tbl_id3154015">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US">
+<image id="img_id3153710" src="cmd/sc_insertrows.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153710" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US">Insert Rows</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="syspaltenganze">
+<table id="tbl_id3147338">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US">
+<image id="img_id3145232" src="cmd/sc_insertcolumns.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145232" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US">Insert Columns</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US"><variable id="eitab">Choose <menuitem>Sheet - Insert Sheet</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US"><variable id="eitabfile">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph>
+<section id="eifu">
+<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US">Choose <menuitem>Insert - Function</menuitem>.</paragraph>
+<paragraph role="paragraph" id="par_id3152582" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
+ <paragraph role="paragraph" id="par_id3153269" xml-lang="en-US">On the <emph>Formula</emph> bar, click</paragraph>
+<section id="syfunktionsautopilot">
+<table id="tbl_id3145258">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US">
+<image id="img_id3150884" src="sw/res/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150884" xml-lang="en-US">Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US">Function Wizard</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</section>
+<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US"><variable id="eikada"><emph>Insert - Function</emph> - Category <emph>Database</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date &amp; Time</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3151334" xml-lang="en-US"><variable id="eikafi"><emph>Insert - Function</emph> - Category <emph>Financial</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US"><variable id="eikain"><emph>Insert - Function</emph> - Category <emph>Information</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3159173" xml-lang="en-US"><variable id="eikalo"><emph>Insert - Function</emph> - Category <emph>Logical</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153914" xml-lang="en-US"><variable id="eikama"><emph>Insert - Function</emph> - Category <emph>Mathematical</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US"><variable id="eikamatrix"><emph>Insert - Function</emph> - Category <emph>Array</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3157978" xml-lang="en-US"><variable id="eikasta"><emph>Insert - Function</emph> - Category <emph>Statistical</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156016" xml-lang="en-US"><variable id="eikatext"><emph>Insert - Function</emph> - Category <emph>Text</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3147075" xml-lang="en-US"><variable id="efefft"><emph>Insert - Function</emph> - Category <emph>Spreadsheet</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="addin"><emph>Insert - Function</emph> - Category <emph>Add-In</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154059" xml-lang="en-US"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US"><variable id="funktionsliste">Choose <menuitem>Insert - Function List</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US"><variable id="einamen">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US"><variable id="eiextdata">Choose <menuitem>Sheet - Link to External Data</menuitem>.</variable></paragraph>
+<section id="einafe">
+<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US">Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>.</paragraph>
+<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US"><variable id="einaei">Choose <menuitem>Sheet - Named Ranges and Expressions - Insert</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US"><variable id="einaueb">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US"><variable id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000405.xhp b/helpcontent2/source/text/scalc/00/00000405.xhp
new file mode 100644
index 000000000..beedce6e7
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000405.xhp
@@ -0,0 +1,79 @@
+<?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="textscalc0000000405xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Format Menu</title>
+ <filename>/text/scalc/00/00000405.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3150769" xml-lang="en-US" level="1">Format Menu</paragraph>
+<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US"><variable id="fozelle">Choose <emph>Format - Cells</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><variable id="fozelstz">Choose <emph>Format - Cells - Cell Protection</emph> tab.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US"><variable id="fozei">Choose <emph>Format - Rows</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US"><variable id="fozeiophoe">Choose <emph>Format - Rows - Optimal Height</emph>.</variable></paragraph>
+<section id="fozeiaus">
+<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US">Choose <emph>Format - Rows - Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US">Choose <emph>Format - Columns - Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Choose <emph>Sheet - Hide Sheet</emph>.</paragraph>
+</section>
+<section id="fozeiebl">
+<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US">Choose <emph>Format - Rows - Show</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US">Choose <emph>Format - Columns - Show</emph>.</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US"><variable id="fospa">Choose <emph>Format - Columns</emph>.</variable></paragraph>
+<section id="fospob">
+<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US">Choose <emph>Format - Columns - Optimal Width</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US">Double-click right column separator in column headers.</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US"><variable id="fot">Choose <emph>Sheet</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US"><variable id="fotu">Choose <emph>Sheet - Rename Sheet</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155333" xml-lang="en-US"><variable id="fotenb">Choose <emph>Sheet - Show Sheet</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_idN1077A" xml-lang="en-US"><variable id="foste">Choose <emph>Format - Page</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155508" xml-lang="en-US"><variable id="fostel">Choose <emph>Format - Page - Sheet</emph> tab.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150883" xml-lang="en-US"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156290" xml-lang="en-US"><variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US"><variable id="fodbah">Choose <emph>Format - Print Ranges - Clear</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153307" xml-lang="en-US"><variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
+<section id="foatfo">
+<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US">Choose <emph>Format - AutoFormat Styles</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3154532" xml-lang="en-US">On the <emph>Tools</emph> bar, click</paragraph>
+<section id="syautoformat">
+<table id="tbl_id3148605">
+<tablerow>
+<tablecell>
+<paragraph role="paragraph" id="par_id3149332" xml-lang="en-US">
+<image id="img_id3156020" src="cmd/sc_autoformat.svg" width="1cm" height="1cm"><alt id="alt_id3156020" xml-lang="en-US">AutoFormat Styles Icon</alt></image></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="paragraph" id="par_id3154060" xml-lang="en-US">AutoFormat</paragraph>
+</tablecell>
+</tablerow>
+</table>
+</section>
+</section>
+<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="bedingte">Choose <emph>Format - Conditional</emph>.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000406.xhp b/helpcontent2/source/text/scalc/00/00000406.xhp
new file mode 100644
index 000000000..3d52e1719
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000406.xhp
@@ -0,0 +1,66 @@
+<?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="textscalc0000000406xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Tools Menu</title>
+ <filename>/text/scalc/00/00000406.xhp</filename>
+ </topic>
+</meta>
+<body>
+<paragraph id="hd_id3147264" role="heading" level="1" xml-lang="en-US">Tools Menu</paragraph>
+<paragraph id="par_id3150541" role="paragraph" xml-lang="en-US"><variable id="exdektv">Choose <emph>Tools - Detective</emph>.</variable></paragraph>
+
+<section id="exdszv">
+<paragraph id="par_id3153194" role="paragraph" xml-lang="en-US">Choose <emph>Tools - Detective - Trace Precedents</emph>.</paragraph>
+<paragraph id="par_id3150447" role="paragraph" xml-lang="en-US">Shift+F7</paragraph>
+</section>
+<paragraph id="par_id3154123" role="paragraph" xml-lang="en-US"><variable id="silbentrennungc">Menu <emph>Tools - Language - Hyphenation</emph>.</variable></paragraph>
+<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US"><variable id="exdvore">Choose <emph>Tools - Detective - Remove Precedents</emph>.</variable></paragraph>
+
+<section id="exdsznf">
+<paragraph id="par_id3155411" role="paragraph" xml-lang="en-US">Choose <emph>Tools - Detective - Trace Dependents</emph>.</paragraph>
+<paragraph id="par_id3153363" role="paragraph" xml-lang="en-US">Shift+F5</paragraph>
+</section>
+<paragraph id="par_id3146984" role="paragraph" xml-lang="en-US"><variable id="exdszne">Choose <emph>Tools - Detective - Remove Dependents</emph>.</variable></paragraph>
+<paragraph id="par_id3154014" role="paragraph" xml-lang="en-US"><variable id="exdase">Choose <emph>Tools - Detective - Remove All Traces</emph>.</variable></paragraph>
+<paragraph id="par_id3153188" role="paragraph" xml-lang="en-US"><variable id="exdszfe">Choose <emph>Tools - Detective - Trace Error</emph>.</variable></paragraph>
+<paragraph id="par_id3149410" role="paragraph" xml-lang="en-US"><variable id="fuellmodus">Choose <emph>Tools - Detective - Fill Mode</emph>.</variable></paragraph>
+<paragraph id="par_id3156284" role="paragraph" xml-lang="en-US"><variable id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid Data</emph>.</variable></paragraph>
+<paragraph id="par_id3153159" role="paragraph" xml-lang="en-US"><variable id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh Traces</emph>.</variable></paragraph>
+<paragraph id="par_id3147397" role="paragraph" xml-lang="en-US"><variable id="automatisch">Choose <emph>Tools - Detective - AutoRefresh</emph>.</variable></paragraph>
+<paragraph id="par_id3154018" role="paragraph" xml-lang="en-US"><variable id="exzws">Choose <emph>Tools - Goal Seek</emph>.</variable></paragraph>
+<paragraph id="par_id3269142" role="paragraph" xml-lang="en-US"><variable id="solver">Choose <emph>Tools - Solver</emph>.</variable></paragraph>
+<paragraph id="par_id8554338" role="paragraph" xml-lang="en-US"><variable id="solver_options">Choose <emph>Tools - Solver</emph>, click <emph>Options</emph> button.</variable></paragraph>
+<paragraph id="par_id3156277" role="paragraph" xml-lang="en-US"><variable id="exsze">Choose <emph>Tools - Scenarios</emph>.</variable></paragraph>
+<paragraph id="par_id3149020" role="paragraph" xml-lang="en-US"><variable id="protect_sheet">Choose <emph>Tools - Protect Sheet</emph>.</variable></paragraph>
+<paragraph id="par_id3154256" role="paragraph" xml-lang="en-US"><variable id="protect_spreadsheet">Choose <emph>Tools - Protect Spreadsheet Structure</emph>.</variable></paragraph>
+
+<section id="exnb">
+<paragraph id="par_id3146919" role="paragraph" xml-lang="en-US">Choose <emph>Data - Calculate - Recalculate</emph>.</paragraph>
+<paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">F9</paragraph>
+</section>
+<section id="exnbr">
+<paragraph id="par_id3146919a" role="paragraph" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Formula</emph>.</paragraph>
+</section>
+<paragraph id="par_id3150941" role="paragraph" xml-lang="en-US"><variable id="exatmb">Choose <emph>Data - Calculate - AutoCalculate</emph>.</variable></paragraph>
+<paragraph id="par_id3151276" role="paragraph" xml-lang="en-US"><variable id="autoeingabe">Choose <emph>Tools - AutoInput</emph>.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000407.xhp b/helpcontent2/source/text/scalc/00/00000407.xhp
new file mode 100644
index 000000000..8623bb0ac
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000407.xhp
@@ -0,0 +1,32 @@
+<?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="textscalc0000000407xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Window Menu</title>
+ <filename>/text/scalc/00/00000407.xhp</filename>
+ </topic>
+</meta>
+<body>
+<paragraph id="hd_id3155628" role="heading" level="1" xml-lang="en-US">Window Menu</paragraph>
+<paragraph id="par_id3147335" role="paragraph" xml-lang="en-US"><variable id="fete">Choose ><item type="menuitem">View - Split Window</item>.</variable></paragraph>
+<paragraph id="par_id3153663" role="paragraph" xml-lang="en-US"><variable id="fefix">Choose <item type="menuitem">View - Freeze Cells - Freeze Rows and Columns</item>.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/00000412.xhp b/helpcontent2/source/text/scalc/00/00000412.xhp
new file mode 100644
index 000000000..c6de85323
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/00000412.xhp
@@ -0,0 +1,172 @@
+<?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="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Data Menu</title>
+ <filename>/text/scalc/00/00000412.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <h1 id="hd_id3145136">Data Menu</h1>
+ <paragraph role="paragraph" id="par_id8366954" xml-lang="en-US"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3147399" xml-lang="en-US"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3145345" xml-lang="en-US"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3150443" xml-lang="en-US"><variable id="dnsrt">Choose <emph>Data - Sort...</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id641584647437810"><variable id="datasortascending">Choose <menuitem>Data - Sort Ascending</menuitem></variable></paragraph>
+ <paragraph role="paragraph" id="par_id711584647447316"><variable id="datasortdescending">Choose <menuitem>Data - Sort Descending</menuitem></variable></paragraph>
+ <section id="dnsosk">
+ <paragraph role="paragraph" id="par_id3148491" xml-lang="en-US">Choose <emph>Data - Sort - Sort Criteria</emph> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id3154516" xml-lang="en-US"><variable id="onthestandardbar">On <emph>Standard</emph> bar, click</variable></paragraph>
+ <section id="sysortieren">
+ <section id="sortascending">
+ <table id="tbl_id3156023">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3148663" xml-lang="en-US">
+ <image id="img_id3150543" src="cmd/sc_sortup.png" width="1cm" height="1cm"><alt id="alt_id3150543" xml-lang="en-US">Icon Sort Ascending</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">Sort Ascending</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <section id="sortdescending">
+ <table id="tbl_id3256023">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US">
+ <image id="img_id3125863" src="cmd/sc_sortdown.png" width="1cm" height="1cm"><alt id="alt_id3125863" xml-lang="en-US">Icon Sort Descending</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3145364" xml-lang="en-US">Sort Descending</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ </section>
+ <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3155308" xml-lang="en-US"><variable id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph>
+ <section id="dnfiafi">
+ <paragraph role="paragraph" id="par_id3148646" xml-lang="en-US">Choose <emph>Data - AutoFilter</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3151113" xml-lang="en-US">On <emph>Tools</emph> bar or <emph>Table Data</emph> bar, click</paragraph>
+ <section id="syautofilter">
+ <table id="tbl_id3155418">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3145799" xml-lang="en-US">
+ <image id="img_id3149413" src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149401" xml-lang="en-US">AutoFilter</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ <paragraph role="paragraph" id="par_id3156278" xml-lang="en-US"><variable id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph> .</variable></paragraph>
+ <section id="filterzus">
+ <paragraph role="paragraph" id="par_id3153764" xml-lang="en-US">Choose <emph>Data - More Filters - Standard Filter... - Options</emph> label.</paragraph>
+ <paragraph role="paragraph" id="par_id3155444" xml-lang="en-US">Choose <emph>Data - More Filters - Advanced Filter... - Options</emph> label.</paragraph>
+ </section>
+ <section id="dnfief">
+ <paragraph role="paragraph" id="par_id3156382" xml-lang="en-US">Choose <emph>Data - More Filters - Reset Filter</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3155961" xml-lang="en-US">On <emph>Table Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph>
+ <table id="tbl_id3146919">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3148485" xml-lang="en-US">
+ <image id="img_id3145792" src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149207" xml-lang="en-US">Reset Filter/Sort</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <paragraph role="paragraph" id="par_id3152778" xml-lang="en-US"><variable id="dnaftas">Choose <emph>Data - More Filter - Hide AutoFilter</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3166424" xml-lang="en-US"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154574" xml-lang="en-US"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3151277" xml-lang="en-US"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3145133" xml-lang="en-US"><variable id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3152992" xml-lang="en-US"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3150367" xml-lang="en-US"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154486" xml-lang="en-US"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3146978" xml-lang="en-US"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3148701" xml-lang="en-US"><variable id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3159223" xml-lang="en-US"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph>
+ <section id="dnglgr">
+ <paragraph role="paragraph" id="par_id3146870" xml-lang="en-US">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3144507" xml-lang="en-US">F12</paragraph>
+ <paragraph role="paragraph" id="par_id3144772" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph>
+ <section id="sygruppieren">
+ <table id="tbl_id3154532">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149438" xml-lang="en-US">
+ <image id="img_id3153287" src="cmd/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Group</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ <section id="dnglgra">
+ <paragraph role="paragraph" id="par_id3146781" xml-lang="en-US">Choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3150892" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
+ <paragraph role="paragraph" id="par_id3155097" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph>
+ <section id="sygruppierungaufheben">
+ <table id="tbl_id3143223">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150048" xml-lang="en-US">
+ <image id="img_id3155914" src="cmd/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153555" xml-lang="en-US">Ungroup</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ <paragraph role="paragraph" id="par_id3153008" xml-lang="en-US"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154709" xml-lang="en-US"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove Outline</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id1774346" xml-lang="en-US"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3155759" xml-lang="en-US"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154625" xml-lang="en-US"><variable id="dndpa">Choose <emph>Insert - Pivot Table</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3147558" xml-lang="en-US"><variable id="dndq">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>.</variable></paragraph>
+ <section id="dndpaz">
+ <paragraph role="paragraph" id="par_id3153297" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Current selection</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3145118" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id3153294" xml-lang="en-US"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3151344" xml-lang="en-US"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3150397" xml-lang="en-US"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/avail_release.xhp b/helpcontent2/source/text/scalc/00/avail_release.xhp
new file mode 100644
index 000000000..52e5e790c
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/avail_release.xhp
@@ -0,0 +1,81 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="availablerelease" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Available since release</title>
+ <filename>/text/scalc/00/avail_release.xhp</filename>
+ </topic>
+ </meta>
+
+ <body>
+ <section id="3.3">
+ <tip id="par_id651551701041690">This function is available since %PRODUCTNAME 3.3.</tip>
+ </section>
+ <section id="3.4">
+ <tip id="par_id651551401041690">This function is available since %PRODUCTNAME 3.4.</tip>
+ </section>
+ <section id="3.5">
+ <tip id="par_id651551401041635">This function is available since %PRODUCTNAME 3.5.</tip>
+ </section>
+ <section id="3.6">
+ <tip id="par_id651551401041636">This function is available since %PRODUCTNAME 3.6.</tip>
+ </section>
+ <section id="4.0">
+ <tip id="par_id651551401041640">This function is available since %PRODUCTNAME 4.0.</tip>
+ </section>
+ <section id="4.1">
+ <tip id="par_id651551401041641">This function is available since %PRODUCTNAME 4.1.</tip>
+ </section>
+ <section id="4.2">
+ <tip id="par_id651551401041642">This function is available since %PRODUCTNAME 4.2.</tip>
+ </section>
+ <section id="4.3">
+ <tip id="par_id651551401041643">This function is available since %PRODUCTNAME 4.3.</tip>
+ </section>
+ <section id="4.4">
+ <tip id="par_id651551401041644">This function is available since %PRODUCTNAME 4.4.</tip>
+ </section>
+ <section id="5.0">
+ <tip id="par_id651551401041650">This function is available since %PRODUCTNAME 5.0.</tip>
+ </section>
+ <section id="5.1">
+ <tip id="par_id651551401041651">This function is available since %PRODUCTNAME 5.1.</tip>
+ </section>
+ <section id="5.2">
+ <tip id="par_id651551401041652">This function is available since %PRODUCTNAME 5.2.</tip>
+ </section>
+ <section id="5.3">
+ <tip id="par_id651551401041653">This function is available since %PRODUCTNAME 5.3.</tip>
+ </section>
+ <section id="5.4">
+ <tip id="par_id651551401041654">This function is available since %PRODUCTNAME 5.4.</tip>
+ </section>
+ <section id="6.0">
+ <tip id="par_id651551401041660">This function is available since %PRODUCTNAME 6.0.</tip>
+ </section>
+ <section id="6.1">
+ <tip id="par_id651551401041661">This function is available since %PRODUCTNAME 6.1.</tip>
+ </section>
+ <section id="6.2">
+ <tip id="par_id651551401041662">This function is available since %PRODUCTNAME 6.2.</tip>
+ </section>
+ <section id="6.3">
+ <tip id="par_id651551401041663">This function is available since %PRODUCTNAME 6.3.</tip>
+ </section>
+ <section id="6.4">
+ <tip id="par_id651551401041664">This function is available since %PRODUCTNAME 6.4.</tip>
+ </section>
+ <section id="7.0">
+ <tip id="par_id651551401041665">This function is available since %PRODUCTNAME 7.0.</tip>
+ </section>
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/00/sheet_menu.xhp b/helpcontent2/source/text/scalc/00/sheet_menu.xhp
new file mode 100644
index 000000000..2264ccae8
--- /dev/null
+++ b/helpcontent2/source/text/scalc/00/sheet_menu.xhp
@@ -0,0 +1,40 @@
+<?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="textscalc0000000404xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Sheet Menu</title>
+ <filename>/text/scalc/00/sheet_menu.xhp</filename>
+ </topic>
+</meta>
+<body>
+<paragraph id="hd_id160220162108024368" role="heading" level="1" xml-lang="en-US">Sheet Menu</paragraph>
+<paragraph id="par_id160220162106567373" role="paragraph" xml-lang="en-US"><variable id="insert_rows_above">Choose <emph>Sheet - Insert Rows - Rows Above</emph>.</variable></paragraph>
+<paragraph id="par_id160220162109048207" role="paragraph" xml-lang="en-US"><variable id="insert_rows_below">Choose <emph>Sheet - Insert Rows - Rows Below</emph>.</variable></paragraph>
+<paragraph id="par_id160220162107055028" role="paragraph" xml-lang="en-US"><variable id="insert_columns_left">Choose <emph>Sheet - Insert Columns - Columns Before</emph>.</variable></paragraph>
+<paragraph id="par_id160220162109126013" role="paragraph" xml-lang="en-US"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns After</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US"><variable id="insert_page_break">Choose <emph>Sheet - Insert Page Break</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US"><variable id="insert_page_break_row">Choose <emph>Sheet - Insert Page Break - Row Break</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US"><variable id="insert_page_break_column">Choose <emph>Sheet - Insert Page Break - Column Break</emph>.</variable></paragraph>
+<paragraph id="par_id3153093" role="paragraph" xml-lang="en-US"><variable id="delete_page_break">Choose <emph>Sheet - Delete Page Break</emph>.</variable></paragraph>
+<paragraph id="par_id3153191" role="paragraph" xml-lang="en-US"><variable id="delete_page_break_row">Choose <emph>Sheet - Delete Page Break - Row Break</emph>.</variable></paragraph>
+<paragraph id="par_id3145645" role="paragraph" xml-lang="en-US"><variable id="delete_page_break_column">Choose <emph>Sheet - Delete Page Break - Column Break</emph>.</variable></paragraph>
+</body>
+</helpdocument>