tdf#155876 Calc UI - Tools menu review

+ Refactor Change-Id: I7bafaf32d0ae4561bafff7d2f42ee3256452ec66 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/157389 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-09-28 19:06:29 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-09-29 02:46:33 +0200
commit: 59e38b61f4aecf25633770d24ac60fc7d3210705 (patch)
tree: 19f92c1e1c57d86301249a5e194e3b75cbb304b6 /source/text
parent: 1c93d4ba6e0b516918ff22c8cdcbc9b808a491ad (diff)
6 files changed, 106 insertions, 80 deletions
diff --git a/source/text/scalc/01/06040000.xhp b/source/text/scalc/01/06040000.xhp
index ec07d7caad..d4d52b2230 100644
--- a/source/text/scalc/01/06040000.xhp
+++ b/source/text/scalc/01/06040000.xhp
@@ -22,31 +22,34 @@
 
 <meta>
 <topic id="textscalc0106040000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Goal Seek</title>
+<title id="tit">Goal Seek</title>
 <filename>/text/scalc/01/06040000.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:GoalSeekDialog" id="bm_id4741970" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/GoalSeekDialog" id="bm_id3153088" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/@@nowidget@@" id="bm_id3153088" localize="false"/>
-<h1 id="hd_id3155629">Goal Seek</h1>
-<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><variable id="zielwertsuchetext"><ahelp hid=".uno:GoalSeekDialog">Opens a dialog where you can solve an equation with a variable.</ahelp>
-</variable> After a successful search, a dialog with the results opens, allowing you to apply the result and the target value directly to the cell.</paragraph>
+<bookmark branch="hid/.uno:GoalSeekDialog" id="bm_id4741970" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/GoalSeekDialog" id="bm_id3153088" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/@@nowidget@@" id="bm_id3153088" localize="false"/>
+
+<section id="goalseek">
+    <h1 id="hd_id3155629"><variable id="h1"><link href="text/scalc/01/06040000.xhp">Goal Seek</link></variable></h1>
+    <paragraph role="paragraph" id="par_id3145119"><variable id="zielwertsuchetext"><ahelp hid=".uno:GoalSeekDialog">Opens a dialog where you can solve an equation with a variable.</ahelp></variable> After a successful search, a dialog with the results opens, allowing you to apply the result and the target value directly to the cell.</paragraph>
+</section>
+
 <section id="howtoget">
 <embed href="text/scalc/00/00000406.xhp#exzws"/>
 </section>
 <h2 id="hd_id3149656">Default</h2>
-<paragraph role="paragraph" id="par_id3151211" xml-lang="en-US">In this section, you can define the variables in your formula.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/formulaedit" id="bm_id3145171" localize="false"/>
+<paragraph role="paragraph" id="par_id3151211">In this section, you can define the variables in your formula.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/formulaedit" id="bm_id3145171" localize="false"/>
 <h3 id="hd_id3150869">Formula cell</h3>
-<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><ahelp hid="modules/scalc/ui/goalseekdlg/formulaedit">In the formula cell, enter the reference of the cell which contains the formula. It contains the current cell reference.</ahelp> Click another cell in the sheet to apply its reference to the text box.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/target" id="bm_id3150441" localize="false"/>
+<paragraph role="paragraph" id="par_id3153194"><ahelp hid="modules/scalc/ui/goalseekdlg/formulaedit">In the formula cell, enter the reference of the cell which contains the formula. It contains the current cell reference.</ahelp> Click another cell in the sheet to apply its reference to the text box.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/target" id="bm_id3150441" localize="false"/>
 <h3 id="hd_id3154685">Target value</h3>
-<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><ahelp hid="modules/scalc/ui/goalseekdlg/target">Specifies the value you want to achieve as a new result.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/varedit" id="bm_id3154013" localize="false"/>
+<paragraph role="paragraph" id="par_id3146984"><ahelp hid="modules/scalc/ui/goalseekdlg/target">Specifies the value you want to achieve as a new result.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/varedit" id="bm_id3154013" localize="false"/>
 <h3 id="hd_id3150012">Variable cell</h3>
-<paragraph role="paragraph" id="par_id3147427" xml-lang="en-US"><ahelp hid="modules/scalc/ui/goalseekdlg/varedit">Specifies the reference for the cell that contains the value you want to adjust in order to reach the target.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147427"><ahelp hid="modules/scalc/ui/goalseekdlg/varedit">Specifies the reference for the cell that contains the value you want to adjust in order to reach the target.</ahelp></paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/06050000.xhp b/source/text/scalc/01/06050000.xhp
index 2d2ff4401d..b7a9b688f3 100644
--- a/source/text/scalc/01/06050000.xhp
+++ b/source/text/scalc/01/06050000.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   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="textscalc0106050000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Create Scenario</title>
+<title id="tit">Create Scenario</title>
 <filename>/text/scalc/01/06050000.xhp</filename>
 </topic>
 <history>
@@ -30,50 +27,53 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:ScenarioManager" id="bm_id3154490" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/ScenarioDialog" id="bm_id3145068" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/@@nowidget@@" id="bm_id3145068" localize="false"/>
-<h1 id="hd_id3156023">Create Scenario</h1>
-<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US"><variable id="szenariotext"><ahelp hid=".">Defines a scenario for the selected sheet area.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:ScenarioManager" id="bm_id3154490" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/ScenarioDialog" id="bm_id3145068" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/@@nowidget@@" id="bm_id3145068" localize="false"/>
+
+<section id="scenarios">
+  <h1 id="hd_id3156023"><variable id="h1"><link href="text/scalc/01/06050000.xhp">Scenarios</link></variable></h1>
+<paragraph role="paragraph" id="par_id3150541"><variable id="szenariotext"><ahelp hid=".">Defines a scenario for the selected sheet area.</ahelp></variable></paragraph>
+</section>
+
 <section id="howtoget">
   <embed href="text/scalc/00/00000406.xhp#exsze"/>
 </section>
-<paragraph role="paragraph" id="par_idN10637" xml-lang="en-US" localize="false">
+<paragraph role="paragraph" id="par_idN10637" localize="false">
 	<embedvar href="text/scalc/guide/scenario.xhp#scenario"/>
 </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/name" id="bm_id3154123" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_TOP" id="bm_id3153195" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/name" id="bm_id3154123" localize="false"/>
+<bookmark branch="hid/SC_HID_SC_SCENWIN_TOP" id="bm_id3153195" localize="false"/>
 <h2 id="hd_id3156280">Name of scenario</h2>
-<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US"><ahelp hid=".">Defines the name for the scenario. Use a clear and unique name so you can easily identify the scenario.</ahelp> You can also modify a scenario name in the Navigator through the <emph>Properties </emph>context menu command.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/comment" id="bm_id3152596" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_BOTTOM" id="bm_id3156444" localize="false"/>
+<paragraph role="paragraph" id="par_id3151041"><ahelp hid=".">Defines the name for the scenario. Use a clear and unique name so you can easily identify the scenario.</ahelp> You can also modify a scenario name in the Navigator through the <emph>Properties </emph>context menu command.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/comment" id="bm_id3152596" localize="false"/>
+<bookmark branch="hid/SC_HID_SC_SCENWIN_BOTTOM" id="bm_id3156444" localize="false"/>
 <h2 id="hd_id3153954">Comment</h2>
-<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US"><ahelp hid=".">Specifies additional information about the scenario. This information will be displayed in the <link href="text/scalc/01/02110000.xhp">Navigator</link> when you click the <emph>Scenarios</emph> icon and select the desired scenario.</ahelp> You can also modify this information in the Navigator through the <emph>Properties </emph>context menu command.</paragraph>
+<paragraph role="paragraph" id="par_id3155411"><ahelp hid=".">Specifies additional information about the scenario. This information will be displayed in the <link href="text/scalc/01/02110000.xhp">Navigator</link> when you click the <emph>Scenarios</emph> icon and select the desired scenario.</ahelp> You can also modify this information in the Navigator through the <emph>Properties </emph>context menu command.</paragraph>
 <h2 id="hd_id3145273">Settings</h2>
-<paragraph role="paragraph" id="par_id3153364" xml-lang="en-US">This section is used to define some of the settings used in the scenario display.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/showframe" id="bm_id3151119" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/bordercolor" id="bm_id3151118" localize="false"/>
+<paragraph role="paragraph" id="par_id3153364">This section is used to define some of the settings used in the scenario display.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/showframe" id="bm_id3151119" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/bordercolor" id="bm_id3151118" localize="false"/>
 <h3 id="hd_id3145367">Display border<comment>UFI: #i38688#</comment></h3>
-<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US"><ahelp hid=".">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/copyback" id="bm_id3147124" localize="false"/>
+<paragraph role="paragraph" id="par_id3151073"><ahelp hid=".">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/copyback" id="bm_id3147124" localize="false"/>
 <h3 id="hd_id3149582">Copy back</h3>
-<paragraph role="paragraph" id="par_id3154942" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scenariodialog/copyback">Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/copysheet" id="bm_id3153418" localize="false"/>
+<paragraph role="paragraph" id="par_id3154942"><ahelp hid="modules/scalc/ui/scenariodialog/copyback">Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/copysheet" id="bm_id3153418" localize="false"/>
 <h3 id="hd_id3149402">Copy entire sheet</h3>
-<paragraph role="paragraph" id="par_id3146969" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scenariodialog/copysheet">Copies the entire sheet into an additional scenario sheet. </ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/preventchanges" id="bm_id3014007" localize="false"/>
+<paragraph role="paragraph" id="par_id3146969"><ahelp hid="modules/scalc/ui/scenariodialog/copysheet">Copies the entire sheet into an additional scenario sheet. </ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/scenariodialog/preventchanges" id="bm_id3014007" localize="false"/>
 <h3 id="par_idN1075A">Prevent changes</h3>
-<paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scenariodialog/preventchanges">Prevents changes to the active scenario. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_idN1075E"><ahelp hid="modules/scalc/ui/scenariodialog/preventchanges">Prevents changes to the active scenario. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="paragraph" id="par_idN10778" xml-lang="en-US">You can only change the scenario properties if the <emph>Prevent changes</emph> option is not selected and if the sheet is not protected.</paragraph>
+<paragraph role="paragraph" id="par_idN10778">You can only change the scenario properties if the <emph>Prevent changes</emph> option is not selected and if the sheet is not protected.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN10780" xml-lang="en-US">You can only edit cell values if the <emph>Prevent changes</emph> option is selected, if the <emph>Copy back</emph> is option is not selected, and if the cells are not protected.</paragraph>
+<paragraph role="paragraph" id="par_idN10780">You can only edit cell values if the <emph>Prevent changes</emph> option is selected, if the <emph>Copy back</emph> is option is not selected, and if the cells are not protected.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN1078C" xml-lang="en-US">You can only change scenario cell values and write them back into the scenario if the <emph>Prevent changes</emph> option is not selected, if the <emph>Copy back</emph> option is selected, and if the cells are not protected.</paragraph>
+<paragraph role="paragraph" id="par_idN1078C">You can only change scenario cell values and write them back into the scenario if the <emph>Prevent changes</emph> option is not selected, if the <emph>Copy back</emph> option is selected, and if the cells are not protected.</paragraph>
 </listitem>
 </list>
 </body>
diff --git a/source/text/scalc/01/06060200.xhp b/source/text/scalc/01/06060200.xhp
index d590e092b6..e368fc4148 100644
--- a/source/text/scalc/01/06060200.xhp
+++ b/source/text/scalc/01/06060200.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   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="textscalc0106060200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Protecting document</title>
+<title id="tit">Protecting document</title>
 <filename>/text/scalc/01/06060200.xhp</filename>
 </topic>
 <history>
@@ -31,22 +28,29 @@
 </meta>
 <body>
 
-<bookmark xml-lang="en-US" branch="hid/.uno:ToolProtectionDocument" id="bm_id3150791" localize="false"/>
-<h1 id="hd_id3150541">Protecting document</h1>
-<paragraph role="paragraph" id="par_id3145172" xml-lang="en-US"><variable id="dokumenttext"><ahelp hid=".uno:ToolProtectionDocument">Protects the sheet structure of your document from modifications. It is impossible to insert, delete, rename, move or copy sheets.</ahelp></variable> Open the <emph>Protect spreadsheet structure</emph> dialog with <emph>Tools - Protect Spreadsheet Structure</emph>. Optionally enter a password and click OK.</paragraph>
+<bookmark branch="hid/.uno:ToolProtectionDocument" id="bm_id3150791" localize="false"/>
+
+<section id="protectstructure">
+  <h1 id="hd_id3150541"><variable id="h1"><link href="text/scalc/01/06060200.xhp#protect spreadsheet structure">Protect Spreadsheet Structure</link></variable></h1>
+  <paragraph role="paragraph" id="par_id3145172"><variable id="dokumenttext"><ahelp hid=".uno:ToolProtectionDocument">Protects the sheet structure of your document from modifications. It is impossible to insert, delete, rename, move or copy sheets.</ahelp></variable></paragraph>
+</section>
+
+<paragraph role="paragraph" id="par_id981695937865582">Optionally enter a password and click OK.</paragraph>
+
 <section id="howtoget">
   <embed href="text/scalc/00/00000406.xhp#protect_spreadsheet"/>
 </section>
-<paragraph role="paragraph" id="par_id3153188" xml-lang="en-US">The structure of protected spreadsheet documents can be changed only if the <emph>Protect</emph> option is disabled. On the context menus for the spreadsheet tabs at the lower graphic border, only the menu item <emph>Select All Sheets</emph> can be activated. All other menu items are deactivated. To remove the protection, call up the command <emph>Tools - Protect Spreadsheet Structure</emph> again. If no password is assigned, protection is immediately removed. If you were assigned a password, the <emph>Remove Spreadsheet Protection</emph> dialog appears, in which you must enter the password. Only then can you remove the check mark specifying that protection is active.</paragraph>
-<paragraph role="paragraph" id="par_id3145750" xml-lang="en-US">A protected document, once saved, can only be saved again with the <emph>File - Save As</emph> menu command. </paragraph>
 
-<bookmark xml-lang="en-US" branch="hid/SC_HID_PASSWD_DOC" id="bm_id3154863" localize="false"/>
+<paragraph role="paragraph" id="par_id3153188">The structure of protected spreadsheet documents can be changed only if the <emph>Protect</emph> option is disabled. On the context menus for the spreadsheet tabs at the lower graphic border, only the menu item <emph>Select All Sheets</emph> can be activated. All other menu items are deactivated. To remove the protection, call up the command <emph>Tools - Protect Spreadsheet Structure</emph> again. If no password is assigned, protection is immediately removed. If you were assigned a password, the <emph>Remove Spreadsheet Protection</emph> dialog appears, in which you must enter the password. Only then can you remove the check mark specifying that protection is active.</paragraph>
+<paragraph role="paragraph" id="par_id3145750">A protected document, once saved, can only be saved again with the <emph>File - Save As</emph> menu command. </paragraph>
+
+<bookmark branch="hid/SC_HID_PASSWD_DOC" id="bm_id3154863" localize="false"/>
 <h2 id="hd_id3152596">Password (optional)</h2>
-<paragraph role="paragraph" id="par_id3155412" xml-lang="en-US"><ahelp hid="SC_HID_PASSWD_DOC">You can create a password to protect your document against unauthorized or accidental modifications.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155412"><ahelp hid="SC_HID_PASSWD_DOC">You can create a password to protect your document against unauthorized or accidental modifications.</ahelp></paragraph>
 
-<bookmark xml-lang="en-US" branch="hid/SC_HID_PASSWD_DOC_CONFIRM" id="bm_id3154864" localize="false"/>
-<paragraph role="paragraph" id="par_id3155413" xml-lang="en-US"><ahelp hid="SC_HID_PASSWD_DOC_CONFIRM" visibility="hidden">Re-enter the password.</ahelp></paragraph>
+<bookmark branch="hid/SC_HID_PASSWD_DOC_CONFIRM" id="bm_id3154864" localize="false"/>
+<paragraph role="paragraph" id="par_id3155413"><ahelp hid="SC_HID_PASSWD_DOC_CONFIRM" visibility="hidden">Re-enter the password.</ahelp></paragraph>
 
-<paragraph role="note" id="par_id3150717" xml-lang="en-US">You can completely protect your work by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password entry. If you want to prevent the document from being opened by other users, select <emph>Save With Password </emph>and click the <emph>Save</emph> button. The <emph>Enter Password</emph> dialog appears. Consider carefully when choosing a password; if you forget it after you close a document you will be unable to access the document.</paragraph>
+<note id="par_id3150717">You can completely protect your work by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password entry. If you want to prevent the document from being opened by other users, select <emph>Save With Password </emph>and click the <emph>Save</emph> button. The <emph>Enter Password</emph> dialog appears. Consider carefully when choosing a password; if you forget it after you close a document you will be unable to access the document.</note>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/06130000.xhp b/source/text/scalc/01/06130000.xhp
index f00a138ecc..4135e5c411 100644
--- a/source/text/scalc/01/06130000.xhp
+++ b/source/text/scalc/01/06130000.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   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="textscalc0106130000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">AutoInput</title>
+<title id="tit">AutoInput</title>
 <filename>/text/scalc/01/06130000.xhp</filename>
 </topic>
 <history>
@@ -30,32 +27,37 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id2486037"><bookmark_value>entering entries with AutoInput function</bookmark_value>
+<bookmark branch="index" id="bm_id2486037"><bookmark_value>entering entries with AutoInput function</bookmark_value>
 <bookmark_value>capital letters;AutoInput function</bookmark_value>
 </bookmark><comment>mw made "entering..." a one level entry</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:AutoComplete" id="bm_id6682843" localize="false"/>
-<h1 id="hd_id3148492"><link href="text/scalc/01/06130000.xhp">AutoInput</link></h1>
-<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><ahelp hid=".uno:AutoComplete">Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column.</ahelp> The column is scanned up to a maximum of 2000 cells or 200 different strings.</paragraph>
+<bookmark branch="hid/.uno:AutoComplete" id="bm_id6682843" localize="false"/>
+
+<section id="autoinput">
+  <h1 id="hd_id3148492"><link href="text/scalc/01/06130000.xhp">AutoInput</link></h1>
+<paragraph role="paragraph" id="par_id3150793"><ahelp hid=".uno:AutoComplete">Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column.</ahelp> The column is scanned up to a maximum of 2000 cells or 200 different strings.</paragraph>
+</section>
+
 <embed href="text/scalc/guide/auto_off.xhp#auto_off"/>
+
 <section id="howtoget">
   <embed href="text/scalc/00/00000406.xhp#autoeingabe"/>
 </section>
-<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US">The completion text is highlighted.</paragraph>
+<paragraph role="paragraph" id="par_id3156422">The completion text is highlighted.</paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="paragraph" id="par_idN1065D" xml-lang="en-US">To accept the completion, press <item type="keycode">Enter</item> or a cursor key.</paragraph>
+<paragraph role="paragraph" id="par_idN1065D">To accept the completion, press <item type="keycode">Enter</item> or a cursor key.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN10665" xml-lang="en-US">To append text or to edit the completion, press <item type="keycode">F2</item>.</paragraph>
+<paragraph role="paragraph" id="par_idN10665">To append text or to edit the completion, press <item type="keycode">F2</item>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN1066D" xml-lang="en-US">To view more completions, press <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Command</item></caseinline><defaultinline><item type="keycode">Ctrl</item></defaultinline></switchinline><item type="keycode">+Tab</item> to scroll forward, or <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Command</item></caseinline><defaultinline><item type="keycode">Ctrl</item></defaultinline></switchinline><item type="keycode">+Shift+Tab</item> to scroll backward.</paragraph>
+<paragraph role="paragraph" id="par_idN1066D">To view more completions, press <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Command</item></caseinline><defaultinline><item type="keycode">Ctrl</item></defaultinline></switchinline><item type="keycode">+Tab</item> to scroll forward, or <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Command</item></caseinline><defaultinline><item type="keycode">Ctrl</item></defaultinline></switchinline><item type="keycode">+Shift+Tab</item> to scroll backward.</paragraph>
 </listitem>
 <listitem>
-	<paragraph role="paragraph" id="par_idN10679" xml-lang="en-US">To see a list of all available AutoInput text items for the current column, press <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Option</item></caseinline><defaultinline><item type="keycode">Alt</item></defaultinline></switchinline><item type="keycode">+Down Arrow</item>.</paragraph>
+	<paragraph role="paragraph" id="par_idN10679">To see a list of all available AutoInput text items for the current column, press <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Option</item></caseinline><defaultinline><item type="keycode">Alt</item></defaultinline></switchinline><item type="keycode">+Down Arrow</item>.</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3150439" xml-lang="en-US">When typing formulas using characters that match previous entries, a Help tip will appear listing the last ten functions used from <emph>Function Wizard</emph>, from all defined range names, from all database range names, and from the content of all label ranges.</paragraph>
-<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US">AutoInput is case-sensitive. If, for example, you have written "Total" in a cell, you cannot enter "total" in another cell of the same column without first deactivating AutoInput.</paragraph>
+<paragraph role="paragraph" id="par_id3150439">When typing formulas using characters that match previous entries, a Help tip will appear listing the last ten functions used from <emph>Function Wizard</emph>, from all defined range names, from all database range names, and from the content of all label ranges.</paragraph>
+<paragraph role="paragraph" id="par_id3153363">AutoInput is case-sensitive. If, for example, you have written "Total" in a cell, you cannot enter "total" in another cell of the same column without first deactivating AutoInput.</paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/shared/01/06040000.xhp b/source/text/shared/01/06040000.xhp
index 1579f832c1..d1a09aeb0c 100644
--- a/source/text/shared/01/06040000.xhp
+++ b/source/text/shared/01/06040000.xhp
@@ -20,23 +20,27 @@
 
 <meta>
   <topic id="textshared0106040000xml" indexer="include">
-    <title xml-lang="en-US" id="tit">AutoCorrect</title>
+    <title id="tit">AutoCorrect</title>
     <filename>/text/shared/01/06040000.xhp</filename>
   </topic>
 </meta>
 
 <body>
-  <bookmark xml-lang="en-US" branch="index" id="bm_id3153391">
+  <bookmark branch="index" id="bm_id3153391">
     <bookmark_value>AutoCorrect function;switching on and off</bookmark_value>
     <bookmark_value>AutoComplete, see also AutoCorrect/AutoInput</bookmark_value>
   </bookmark>
-  <bookmark xml-lang="en-US" branch="hid/.uno:AutoCorrectDlg" id="bm_id1521736" localize="false"/>
-  <h1 id="hd_id3153391">AutoCorrect</h1>
-  <paragraph id="par_id3150838" role="paragraph" xml-lang="en-US"><variable id="autoko"><ahelp hid=".uno:AutoCorrectDlg">Sets the options for automatically replacing text as you type.</ahelp></variable></paragraph>
+  <bookmark branch="hid/.uno:AutoCorrectDlg" id="bm_id1521736" localize="false"/>
+
+  <section id="autocorrectdlg">
+    <h1 id="hd_id3153391"><variable id="h1"><link href="text/shared/01/06040000.xhp#autocorrect">AutoCorrect Options</link></variable></h1>
+  <paragraph id="par_id3150838" role="paragraph"><variable id="autoko"><ahelp hid=".uno:AutoCorrectDlg">Sets the options for automatically replacing text as you type.</ahelp></variable></paragraph>
+  </section>
+
   <section id="howtoget">
     <embed href="text/shared/00/00000406.xhp#autokorr"/>
   </section>
-  <paragraph id="par_id3147261" role="paragraph" xml-lang="en-US">To apply an AutoCorrect rule, enter the predefined text in the document and press the <widget>Spacebar</widget>.</paragraph>
+  <paragraph id="par_id3147261" role="paragraph">To apply an AutoCorrect rule, enter the predefined text in the document and press the <widget>Spacebar</widget>.</paragraph>
   <switch select="appl">
     <case select="WRITER">
       <note id="par_id791632159942582">To turn off AutoCorrect in %PRODUCTNAME Writer choose <menuitem>Tools - AutoCorrect - While Typing</menuitem>. Refer to the help page <link href="text/swriter/guide/auto_off.xhp">Turning Off AutoCorrect</link> to learn more about deactivating AutoCorrect in %PRODUCTNAME Writer.</note>
@@ -62,7 +66,7 @@
   <switch select="appl">
     <case select="WRITER">
       <section id="relatedtopics">
-        <paragraph id="par_id3146137" role="paragraph" xml-lang="en-US"><link href="text/swriter/01/05150200.xhp">AutoCorrect</link></paragraph>
+        <paragraph id="par_id3146137" role="paragraph"><link href="text/swriter/01/05150200.xhp">AutoCorrect</link></paragraph>
       </section>
     </case>
   </switch>
diff --git a/source/text/shared/main_tools.xhp b/source/text/shared/main_tools.xhp
index 23f93e4e6c..272e2b7299 100644
--- a/source/text/shared/main_tools.xhp
+++ b/source/text/shared/main_tools.xhp
@@ -66,6 +66,19 @@
             <embed href="text/swriter/01/06100000.xhp#sorttable"/>
         </case>
         <case select="CALC">
+            <embed href="text/shared/01/06040000.xhp#autocorrectdlg"/>
+            <embed href="text/scalc/01/06130000.xhp#autoinput"/>
+            <embed href="text/shared/01/02220000.xhp#imagemap"/>
+            <embed href="text/shared/01/RedactDoc.xhp#redact"/>
+            <embed href="text/shared/01/AutoRedactDoc.xhp#autoredact"/>
+            <embed href="text/scalc/01/06040000.xhp#goalseek"/>
+            <embed href="text/scalc/01/solver.xhp#solverhead"/>
+            <embed href="text/scalc/01/06030000.xhp#detective"/>
+            <embed href="text/scalc/01/06050000.xhp#scenarios"/>
+            <embed href="text/shared/menu/forms.xhp#forms_submenu_Head"/>
+            <embed href="text/scalc/01/shared_spreadsheet.xhp#shared_spreadsheet_head"/>
+            <embed href="text/shared/01/Protect.xhp#protect_sheet"/>
+            <embed href="text/scalc/01/06060200.xhp#protectstructure"/>
         </case>
         <case select="IMPRESS">
         </case>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-09-28 19:06:29 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-09-29 02:46:33 +0200
commit	59e38b61f4aecf25633770d24ac60fc7d3210705 (patch)
tree	19f92c1e1c57d86301249a5e194e3b75cbb304b6 /source/text
parent	1c93d4ba6e0b516918ff22c8cdcbc9b808a491ad (diff)