source/text/scalc/01/06040000.xhp | 31 ++++++++++---------
source/text/scalc/01/06050000.xhp | 60 ++++++++++++++++++-------------------
source/text/scalc/01/06060200.xhp | 32 +++++++++++--------
source/text/scalc/01/06130000.xhp | 32 ++++++++++---------
source/text/shared/01/06040000.xhp | 18 ++++++-----
source/text/shared/main_tools.xhp | 13 ++++++++
6 files changed, 106 insertions(+), 80 deletions(-)
New commits:
commit 59e38b61f4aecf25633770d24ac60fc7d3210705
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Sep 28 19:06:29 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Sep 29 02:46:33 2023 +0200
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.hal...@libreoffice.org>
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>
