summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSophia Schröder <sophia.schroeder@libreoffice.org>2018-05-20 18:11:37 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-06-07 17:44:04 +0200
commit156af0219ea25704b386d6c16dca7e1ce8386995 (patch)
tree8c0b0e4bfb1a9737cc906ad154f7643403e71e0a
parent6d75ce4e4c15dfd0ef135de19977389508d95b8a (diff)
Cleanups and improvements
Help files in scalc/00/ Change-Id: I55ffb4961fb5614f75fbc3e71dd50b461dff17de Reviewed-on: https://gerrit.libreoffice.org/54603 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> (cherry picked from commit 3765355e41d02ee3e5f64ef6ece336641553e7c7) Reviewed-on: https://gerrit.libreoffice.org/55435 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/00/00000004.xhp26
-rw-r--r--source/text/scalc/00/00000402.xhp34
-rw-r--r--source/text/scalc/00/00000403.xhp12
-rw-r--r--source/text/scalc/00/00000404.xhp75
-rw-r--r--source/text/scalc/00/00000405.xhp96
-rw-r--r--source/text/scalc/00/00000406.xhp48
-rw-r--r--source/text/scalc/00/00000407.xhp8
-rw-r--r--source/text/scalc/00/00000412.xhp151
-rw-r--r--source/text/scalc/00/sheet_menu.xhp24
9 files changed, 177 insertions, 297 deletions
diff --git a/source/text/scalc/00/00000004.xhp b/source/text/scalc/00/00000004.xhp
index 49b75e74e..640164de3 100644
--- a/source/text/scalc/00/00000004.xhp
+++ b/source/text/scalc/00/00000004.xhp
@@ -1,7 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -20,22 +18,16 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
- <helpdocument version="1.0">
<meta>
-<topic id="textscalc0000000004xml" indexer="exclude" status="PUBLISH">
-<title id="tit" xml-lang="en-US">To access this function...</title>
-<filename>/text/scalc/00/00000004.xhp</filename>
-</topic>
+ <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>
+<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/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp
index 55800e353..bf8ddefe9 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -24,36 +24,32 @@
<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>
+<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_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>
+<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>
+<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>
+<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/source/text/scalc/00/00000403.xhp b/source/text/scalc/00/00000403.xhp
index 48790edf8..8ae11a39b 100644
--- a/source/text/scalc/00/00000403.xhp
+++ b/source/text/scalc/00/00000403.xhp
@@ -24,15 +24,11 @@
<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>
+<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/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index 55ca30218..05bfeca0d 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -19,31 +18,26 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
-<helpdocument version="1.0">
<meta>
-<topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Insert Menu</title>
-<filename>/text/scalc/00/00000404.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <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>
<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1">Insert Menu</paragraph>
<section id="eize">
-<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US">Choose <emph>Insert - Cells</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US">Open <emph>Insert Cells</emph> toolbar from Tools bar:</paragraph>
+<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US">Choose <emph>Insert - Cells</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US">Open <emph>Insert Cells</emph> toolbar from <emph>Tools</emph> bar:</paragraph>
<section id="syzelleneinfuegen">
<table id="tbl_id3148550">
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US">Insert Cells</paragraph>
@@ -58,8 +52,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US">Insert Cells Down</paragraph>
@@ -73,8 +66,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US">Insert Cells Right</paragraph>
@@ -88,8 +80,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US">Insert Rows</paragraph>
@@ -103,8 +94,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US">Insert Columns</paragraph>
@@ -113,13 +103,10 @@
</table>
</section>
-<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US"><variable id="eitab">Choose <emph>Sheet - Insert Sheet</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US"><variable id="eitabfile">Choose <emph>Sheet - Insert Sheet from File</emph>
-</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US"><variable id="eitab">Choose <emph>Sheet - Insert Sheet</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US"><variable id="eitabfile">Choose <emph>Sheet - Insert Sheet from File</emph>.</variable></paragraph>
<section id="eifu">
-<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US">Choose <emph>Insert - Function</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US">Choose <emph>Insert - Function</emph>.</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 <emph>Formula Bar</emph>, click</paragraph>
<section id="syfunktionsautopilot">
@@ -127,8 +114,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US">Function Wizard</paragraph>
@@ -140,7 +126,7 @@
</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>
+<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>
@@ -162,22 +148,15 @@
</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 <emph>Insert - Function List</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US"><variable id="einamen">Choose <emph>Insert - Named Ranges and Expressions</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US"><variable id="eiextdata">Choose <emph>Sheet - Link to External data</emph>
-</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US"><variable id="einamen">Choose <emph>Insert - Named Ranges and Expressions</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US"><variable id="eiextdata">Choose <emph>Sheet - Link to External data</emph>.</variable></paragraph>
<section id="einafe">
-<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US">Choose <emph>Sheet - Named Ranges and Expressions - Define</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US">Choose <emph>Sheet - Named Ranges and Expressions - Define</emph>.</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 <emph>Sheet - Named Ranges and Expressions - Insert</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US"><variable id="einaueb">Choose <emph>Sheet - Named Ranges and Expressions - Create</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US"><variable id="einabesch">Choose <emph>Sheet - Named Ranges and Expressions - Labels</emph>
-</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US"><variable id="einaei">Choose <emph>Sheet - Named Ranges and Expressions - Insert</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US"><variable id="einaueb">Choose <emph>Sheet - Named Ranges and Expressions - Create</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US"><variable id="einabesch">Choose <emph>Sheet - Named Ranges and Expressions - Labels</emph>.</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index 9ba544c2b..58c0ff157 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -18,79 +17,55 @@
* 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="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>
+ <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 - Row</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US"><variable id="fozeiophoe">Choose <emph>Format - Row - Optimal Height</emph>
-</variable></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 - Row</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US"><variable id="fozeiophoe">Choose <emph>Format - Row - Optimal Height</emph>.</variable></paragraph>
<section id="fozeiaus">
-<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US">Choose <emph>Format - Row - Hide</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US">Choose <emph>Format - Column - Hide</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Choose <emph>Format - Sheet - Hide</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US">Choose <emph>Format - Row - Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US">Choose <emph>Format - Column - Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Choose <emph>Format - Sheet - Hide</emph>.</paragraph>
</section>
<section id="fozeiebl">
-<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US">Choose <emph>Format - Row - Show</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US">Choose <emph>Format - Column - Show</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US">Choose <emph>Format - Row - Show</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US">Choose <emph>Format - Column - Show</emph>.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US"><variable id="fospa">Choose <emph>Format - Column</emph>
-</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US"><variable id="fospa">Choose <emph>Format - Column</emph>.</variable></paragraph>
<section id="fospob">
-<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US">Choose <emph>Format - Column - Optimal Width</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US">Double-click right column separator in column headers</paragraph>
+<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US">Choose <emph>Format - Column - 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>Format - Sheet</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US"><variable id="fotu">Choose <emph>Format - Sheet - Rename</emph>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155333" xml-lang="en-US"><variable id="fotenb">Choose <emph>Format - Sheet - Show</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>
+<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US"><variable id="fot">Choose <emph>Format - Sheet</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US"><variable id="fotu">Choose <emph>Format - Sheet - Rename</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155333" xml-lang="en-US"><variable id="fotenb">Choose <emph>Format - Sheet - Show</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</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3154532" xml-lang="en-US">On the Tools bar, click</paragraph>
+<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US">Choose <emph>Format - AutoFormat</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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3149332" xml-lang="en-US">
-<image id="img_id3156020" src="cmd/sc_autoformat.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156020" xml-lang="en-US">Icon</alt>
- </image></paragraph>
+<image id="img_id3156020" src="cmd/sc_autoformat.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156020" xml-lang="en-US">Icon</alt></image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3154060" xml-lang="en-US">AutoFormat</paragraph>
@@ -100,7 +75,6 @@
</section>
</section>
-<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="bedingte">Choose <emph>Format - Conditional Formatting</emph>
-</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="bedingte">Choose <emph>Format - Conditional Formatting</emph>.</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/00/00000406.xhp b/source/text/scalc/00/00000406.xhp
index bcb89eb44..8818c6805 100644
--- a/source/text/scalc/00/00000406.xhp
+++ b/source/text/scalc/00/00000406.xhp
@@ -24,44 +24,40 @@
<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>
+<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_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>
+<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_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>, <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</emph></variable></paragraph>
+<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</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_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>
-<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>
+<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> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/00/00000407.xhp b/source/text/scalc/00/00000407.xhp
index 2021aeb14..8623bb0ac 100644
--- a/source/text/scalc/00/00000407.xhp
+++ b/source/text/scalc/00/00000407.xhp
@@ -24,13 +24,9 @@
<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>
+<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/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp
index ef5b52252..3274de79a 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -1,7 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -20,34 +18,27 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
- <helpdocument version="1.0">
<meta>
-<topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Data Menu</title>
-<filename>/text/scalc/00/00000412.xhp</filename>
-</topic>
+ <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>
<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1">Data Menu</paragraph>
-<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_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>
<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">On Standard bar, click</paragraph>
+<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">On <emph>Standard</emph> bar, click</paragraph>
<section id="sysortieren">
<table id="tbl_id3156023">
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US">
-<image id="img_id3150543" src="cmd/sc_sortup.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt>
- </image></paragraph>
+<image id="img_id3150543" src="cmd/sc_sortup.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt></image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">Sort Ascending</paragraph>
@@ -56,8 +47,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US">
-<image id="img_id3125863" src="cmd/sc_sortdown.png" width="0.1701inch" height="0.1701inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt>
- </image></paragraph>
+<image id="img_id3125863" src="cmd/sc_sortdown.png" width="0.1701inch" height="0.1701inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt></image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US">Sort Descending</paragraph>
@@ -66,21 +56,17 @@
</table>
</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 - Filter</emph>
-</variable></paragraph>
+<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 - Filter</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 Tools bar or Table Data bar, click</paragraph>
+<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 colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US">AutoFilter</paragraph>
@@ -89,23 +75,19 @@
</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>
+<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>
+<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 Table Data bar, click <emph>Reset Filter/Sort</emph>
-</paragraph>
+<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 colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US">Reset Filter/Sort</paragraph>
@@ -113,35 +95,21 @@
</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>
+<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_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">
@@ -149,8 +117,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Group</paragraph>
@@ -160,8 +127,7 @@
</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_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">
@@ -169,8 +135,7 @@
<tablerow>
<tablecell colspan="" rowspan="">
<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>
+<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 colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US">Ungroup</paragraph>
@@ -179,29 +144,19 @@
</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</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 Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>.
-</variable></paragraph>
+<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</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 Select Source 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 Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph>
+<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>
+<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/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index 04e6e6ac0..41a7be2f7 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -24,21 +24,17 @@
<filename>/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 Left</emph></variable></paragraph>
-<paragraph id="par_id160220162109126013" role="paragraph" xml-lang="en-US"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns Right</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>
+<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 Left</emph>.</variable></paragraph>
+<paragraph id="par_id160220162109126013" role="paragraph" xml-lang="en-US"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns Right</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>