diff options
| author | Sophia Schröder <sophia.schroeder@libreoffice.org> | 2018-05-20 18:11:37 +0100 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2018-06-06 07:53:17 +0200 |
| commit | 3765355e41d02ee3e5f64ef6ece336641553e7c7 (patch) | |
| tree | d622ba6ca6b5f6180c36f6aea0db524fdcba3d8e | |
| parent | 83d31a088aac0ed11189afb26d818f7fb56c9b2e (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>
| -rw-r--r-- | source/text/scalc/00/00000004.xhp | 26 | ||||
| -rw-r--r-- | source/text/scalc/00/00000402.xhp | 34 | ||||
| -rw-r--r-- | source/text/scalc/00/00000403.xhp | 12 | ||||
| -rw-r--r-- | source/text/scalc/00/00000404.xhp | 75 | ||||
| -rw-r--r-- | source/text/scalc/00/00000405.xhp | 96 | ||||
| -rw-r--r-- | source/text/scalc/00/00000406.xhp | 48 | ||||
| -rw-r--r-- | source/text/scalc/00/00000407.xhp | 8 | ||||
| -rw-r--r-- | source/text/scalc/00/00000412.xhp | 151 | ||||
| -rw-r--r-- | source/text/scalc/00/sheet_menu.xhp | 24 |
9 files changed, 177 insertions, 297 deletions
diff --git a/source/text/scalc/00/00000004.xhp b/source/text/scalc/00/00000004.xhp index 49b75e74e9..640164de3b 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 55800e353c..bf8ddefe98 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 48790edf88..8ae11a39b1 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 & 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 & 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 55ca30218f..05bfeca0d7 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&Time</emph> +<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date & 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 9ba544c2be..58c0ff157f 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 bcb89eb446..8818c68057 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 2021aeb149..8623bb0ac2 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 ef5b522522..3274de79a6 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 04e6e6ac0d..41a7be2f7a 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> |