source/text/scalc/00/00000406.xhp | 203 +++++++++++++++++++++++++++++++++++---
source/text/scalc/01/06030000.xhp | 59 +++++------
source/text/scalc/01/06030100.xhp | 25 ++--
source/text/scalc/01/06030200.xhp | 23 ++--
source/text/scalc/01/06030300.xhp | 31 ++---
source/text/scalc/01/06030400.xhp | 29 ++---
source/text/scalc/01/06030500.xhp | 29 ++---
source/text/scalc/01/06030600.xhp | 29 ++---
source/text/scalc/01/06030700.xhp | 25 ++--
source/text/scalc/01/06030800.xhp | 31 ++---
source/text/scalc/01/06030900.xhp | 45 ++++----
source/text/scalc/01/06031000.xhp | 31 ++---
12 files changed, 368 insertions(+), 192 deletions(-)
New commits:
commit 99ae655bc9bddc3d13444213ecf01ac0a2902b32
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Jan 6 20:09:12 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Jan 7 00:31:32 2024 +0100
tdf#155876 UI cmds Calc-Tools menu (54)
+ Tools menu for Calc, Detective
+ fixes
+ refactoring
Change-Id: I917cebbf6a5747b3b0aa09500045ba6bda7f41fa
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161733
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000406.xhp
b/source/text/scalc/00/00000406.xhp
index d39960c18b..0ea5506654 100644
--- a/source/text/scalc/00/00000406.xhp
+++ b/source/text/scalc/00/00000406.xhp
@@ -26,26 +26,203 @@
</meta>
<body>
<h1 id="hd_id3147264">Tools Menu</h1>
-<paragraph id="par_id3150541" role="paragraph"><variable id="exdektv">Choose
<emph>Tools - Detective</emph>.</variable></paragraph>
+
+<section id="detective">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3150541" role="paragraph"><variable id="exdektv">Choose
<emph>Tools - Detective</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id21704574722138">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121704574722139" role="paragraph"><image
src="cmd/lc_auditmenu.svg" id="img_id51704574722140" width="1cm"
height="1cm"><alt id="alt_id691704574722141">Icon
Detective</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id931704574722143"
role="paragraph">Detective</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
<section id="trace_precedents">
-<paragraph id="par_id3153194" role="paragraph">Choose <emph>Tools - Detective
- Trace Precedents</emph>.</paragraph>
-<paragraph id="par_id3150447" role="paragraph">Shift+F9</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3153194" role="paragraph">Choose <emph>Tools -
Detective - Trace Precedents</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id31704582059974">With <menuitem>Fill
Mode</menuitem> active, choose <menuitem>Trace
Precedents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id521704575125111">Choose
<menuitem>Tools - Trace Precedents</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id641704575130968">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Trace Precedents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id491704575178719">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id641704575178720" role="paragraph"><image
src="cmd/lc_showprecedents.svg" id="img_id751704575178721" width="1cm"
height="1cm"><alt id="alt_id221704575178723">Icon Trace
Precedents</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211704575178724" role="paragraph">Trace
Precedents</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph id="par_id3150447"
role="paragraph"><keycode>Shift+F9</keycode></paragraph>
</section>
+
<paragraph id="par_id3154123" role="paragraph"><variable
id="silbentrennungc">Menu <emph>Tools - Language -
Hyphenation</emph>.</variable></paragraph>
-<paragraph id="par_id3145785" role="paragraph"><variable id="exdvore">Choose
<emph>Tools - Detective - Remove Precedents</emph>.</variable></paragraph>
+
+<section id="remove_precedents">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3145785" role="paragraph"><variable id="exdvore">Choose
<emph>Tools - Detective - Remove Precedents</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id801704582093988">With <menuitem>Fill
Mode</menuitem> active, choose <menuitem>Remove
Precedents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id41704575713980">Choose <menuitem>Tools
- Remove Precedents</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id921704575718322">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Remove Precedents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id771704575734398">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id601704575734399" role="paragraph"><image
src="cmd/lc_cleararrowprecedents.svg" id="img_id941704575734400" width="1cm"
height="1cm"><alt id="alt_id41704575734401">Icon Remove
Precedents</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781704575734403" role="paragraph">Remove
Precedents</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
<section id="trace_dependents">
-<paragraph id="par_id3155411" role="paragraph">Choose <emph>Tools - Detective
- Trace Dependents</emph>.</paragraph>
-<paragraph id="par_id3153363" role="paragraph">Shift+F5</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3155411" role="paragraph">Choose <emph>Tools -
Detective - Trace Dependents</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id111704582111559">With <menuitem>Fill
Mode</menuitem> active, choose <menuitem>Trace
Dependents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id561704576171265">Choose
<menuitem>Tools - Trace Dependents</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id551704576174383">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Trace Dependents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id401704576046039">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id151704576046040" role="paragraph"><image
src="cmd/lc_showdependents.svg" id="img_id211704576046041" width="1cm"
height="1cm"><alt id="alt_id641704576046042">Icon Trace
Dependents</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id861704576046044" role="paragraph">Trace
Dependents</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph id="par_id3153363"
role="paragraph"><keycode>Shift+F5</keycode></paragraph>
+</section>
+
+<section id="remove_dependents">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3146984" role="paragraph"><variable id="exdszne">Choose
<emph>Tools - Detective - Remove Dependents</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id611704582150755">With <menuitem>Fill
Mode</menuitem> active, choose <menuitem>Remove
Dependents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id691704576761568">Choose
<menuitem>Tools - Remove Dependents</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id901704576765488">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Remove Dependents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id131704576780895">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id751704576780896" role="paragraph"><image
src="cmd/lc_cleararrowdependents.svg" id="img_id301704576780897" width="1cm"
height="1cm"><alt id="alt_id1001704576780898">Icon Remove
Dependents</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id201704576780900" role="paragraph">Remove
Dependents</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="remove_all">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3154014" role="paragraph"><variable id="exdase">Choose
<emph>Tools - Detective - Remove All Traces</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id851704582262042">With <menuitem>Fill
Mode</menuitem> active, choose <menuitem>Remove All Traces</menuitem>.
</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id761704579736415">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Remove All Traces</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id781704577521491">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id631704577521492" role="paragraph"><image
src="cmd/lc_cleararrows.svg" id="img_id171704577521493" width="1cm"
height="1cm"><alt id="alt_id851704577521494">Icon Remove All
Traces</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id651704577521496" role="paragraph">Remove All
Traces</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="trace_errors">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3153188" role="paragraph"><variable id="exdszfe">Choose
<emph>Tools - Detective - Trace Error</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id571704579944999">Choose
<menuitem>Tools - Trace Error</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id161704577134688">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Trace Error</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id731704578781446">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id971704578781447" role="paragraph"><image
src="cmd/lc_showerrors.svg" id="img_id841704578781448" width="1cm"
height="1cm"><alt id="alt_id311704578781449">Icon Trace
Error</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id931704578781451" role="paragraph">Trace
Error</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="fill_mode">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3149410" role="paragraph"><variable
id="fuellmodus">Choose <emph>Tools - Detective - Fill
Mode</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id951704579401882">Choose
<menuitem>Tools - Fill Mode</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id561704579693511">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Fill Mode</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id821704579346752">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id281704579346753" role="paragraph"><image
src="cmd/lc_auditingfillmode.svg" id="img_id341704579346754" width="1cm"
height="1cm"><alt id="alt_id61704579346755">Icon Fill
Mode</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id221704579346756" role="paragraph">Fill
Mode</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="mark_invalid_data">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3156284" role="paragraph"><variable
id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid
Data</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id241704580224170">Choose
<menuitem>Tools - Mark Invalid Data</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id711704580227978">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Mark Invalid Data</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id871704580188152">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id451704580188153" role="paragraph"><image
src="cmd/lc_showinvalid.svg" id="img_id261704580188154" width="1cm"
height="1cm"><alt id="alt_id831704580188155">Icon Mark Invalid
Data</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id311704580188157" role="paragraph">Mark Invalid
Data</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="refresh_traces">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3153159" role="paragraph"><variable
id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh
Traces</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id671704580574418">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>Refresh Traces</menuitem>.</paragraph>
+</section>
+
+<section id="auto_refresh">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3147397" role="paragraph"><variable
id="automatisch">Choose <emph>Tools - Detective -
AutoRefresh</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id31704581061664">On the
<menuitem>Tools</menuitem> menu of the <menuitem>Tools</menuitem> tab, choose
<menuitem>AutoRefresh</menuitem>.</paragraph>
</section>
-<paragraph id="par_id3146984" role="paragraph"><variable id="exdszne">Choose
<emph>Tools - Detective - Remove Dependents</emph>.</variable></paragraph>
-<paragraph id="par_id3154014" role="paragraph"><variable id="exdase">Choose
<emph>Tools - Detective - Remove All Traces</emph>.</variable></paragraph>
-<paragraph id="par_id3153188" role="paragraph"><variable id="exdszfe">Choose
<emph>Tools - Detective - Trace Error</emph>.</variable></paragraph>
-<paragraph id="par_id3149410" role="paragraph"><variable
id="fuellmodus">Choose <emph>Tools - Detective - Fill
Mode</emph>.</variable></paragraph>
-<paragraph id="par_id3156284" role="paragraph"><variable
id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid
Data</emph>.</variable></paragraph>
-<paragraph id="par_id3153159" role="paragraph"><variable
id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh
Traces</emph>.</variable></paragraph>
-<paragraph id="par_id3147397" role="paragraph"><variable
id="automatisch">Choose <emph>Tools - Detective -
AutoRefresh</emph>.</variable></paragraph>
<section id="goal_seek">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/06030000.xhp
b/source/text/scalc/01/06030000.xhp
index d1d5d8de72..1b4bd79520 100644
--- a/source/text/scalc/01/06030000.xhp
+++ b/source/text/scalc/01/06030000.xhp
@@ -22,34 +22,35 @@
<meta>
<topic id="textscalc0106030000xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Detective</title>
+ <title id="tit">Detective</title>
<filename>/text/scalc/01/06030000.xhp</filename>
</topic>
- </meta>
- <body>
- <section id="detective">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3151245"><bookmark_value>cell links search</bookmark_value>
- <bookmark_value>searching; links in cells</bookmark_value>
- <bookmark_value>traces;precedents and dependents</bookmark_value>
- <bookmark_value>Formula Auditing,see Detective</bookmark_value>
- <bookmark_value>Detective</bookmark_value>
-</bookmark><comment>MW added "Detective" and a cross-reference</comment>
-<h1 id="hd_id3151245"><link
href="text/scalc/01/06030000.xhp">Detective</link></h1>
- <paragraph xml-lang="en-US" id="par_id3151211" role="paragraph">This
command activates the Spreadsheet Detective. With the Detective, you can trace
the dependencies from the current formula cell to the cells in the
spreadsheet.</paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#exdektv"/>
- </section>
- <paragraph xml-lang="en-US" id="par_id3150447" role="paragraph">Once you
have defined a trace, you can point with the mouse cursor to the trace. The
mouse cursor will change its shape. Double-click the trace with this cursor to
select the referenced cell at the end of the trace. <comment>If you define an
icon in the spreadsheet, you can put your cursor on it. It will change into a
magnifying glass with reference arrows. Double-click the visible icon to select
the cell at the furthest end of the icon.</comment></paragraph>
- <embed href="text/scalc/01/06030100.xhp#trace_precedents"/>
- <embed href="text/scalc/01/06030200.xhp#remove_precedents"/>
- <embed href="text/scalc/01/06030300.xhp#trace_dependents"/>
- <embed href="text/scalc/01/06030400.xhp#remove_dependents"/>
- <embed href="text/scalc/01/06030500.xhp#remove_all_traces"/>
- <embed href="text/scalc/01/06030600.xhp#trace_error"/>
- <embed href="text/scalc/01/06030800.xhp#mark_invalid_data"/>
- <embed href="text/scalc/01/06030900.xhp#spurenaktualisieren"/>
- <embed href="text/scalc/01/06031000.xhp#autorefresh"/>
- <embed href="text/scalc/01/06030700.xhp#fill_mode"/>
- </body>
-</helpdocument>
\ No newline at end of file
+</meta>
+<body>
+<bookmark branch="index" id="bm_id3151245"><bookmark_value>cell links
search</bookmark_value>
+ <bookmark_value>searching; links in cells</bookmark_value>
+ <bookmark_value>traces;precedents and dependents</bookmark_value>
+ <bookmark_value>Formula Auditing,see Detective</bookmark_value>
+ <bookmark_value>Detective</bookmark_value>
+ </bookmark><comment>MW added "Detective" and a cross-reference</comment>
+<bookmark branch="hid/.uno:AuditMenu" id="bm_id91704574212670"
localize="false"/>
+<section id="detective">
+ <h1 id="hd_id3151245"><variable id="h1"><link
href="text/scalc/01/06030000.xhp">Detective</link></variable></h1>
+ <paragraph id="par_id3151211" role="paragraph">This command activates the
Spreadsheet Detective. With the Detective, you can trace the dependencies from
the current formula cell to the cells in the spreadsheet.</paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000406.xhp#detective"/>
+</section>
+<paragraph id="par_id3150447" role="paragraph">Once you have defined a trace,
you can point with the mouse cursor to the trace. The mouse cursor will change
its shape. Double-click the trace with this cursor to select the referenced
cell at the end of the trace. <comment>If you define an icon in the
spreadsheet, you can put your cursor on it. It will change into a magnifying
glass with reference arrows. Double-click the visible icon to select the cell
at the furthest end of the icon.</comment></paragraph>
+<embed href="text/scalc/01/06030100.xhp#trace_precedents"/>
+<embed href="text/scalc/01/06030200.xhp#remove_precedents"/>
+<embed href="text/scalc/01/06030300.xhp#trace_dependents"/>
+<embed href="text/scalc/01/06030400.xhp#remove_dependents"/>
+<embed href="text/scalc/01/06030500.xhp#remove_all_traces"/>
+<embed href="text/scalc/01/06030600.xhp#trace_error"/>
+<embed href="text/scalc/01/06030800.xhp#mark_invalid_data"/>
+<embed href="text/scalc/01/06030700.xhp#fill_mode"/>
+<embed href="text/scalc/01/06030900.xhp#spurenaktualisieren"/>
+<embed href="text/scalc/01/06031000.xhp#autorefresh"/>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/06030100.xhp
b/source/text/scalc/01/06030100.xhp
index f6eefa94e8..ca45797c36 100644
--- a/source/text/scalc/01/06030100.xhp
+++ b/source/text/scalc/01/06030100.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="textscalc0106030100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Trace Precedents</title>
+<title id="tit">Trace Precedents</title>
<filename>/text/scalc/01/06030100.xhp</filename>
</topic>
<history>
@@ -30,18 +27,22 @@
</history>
</meta>
<body>
-<section id="trace_precedents">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3155628"><bookmark_value>cells; tracing precedents</bookmark_value>
-<bookmark_value>formula cells;tracing precedents</bookmark_value>
+<bookmark branch="index" id="bm_id3155628"><bookmark_value>cells; tracing
precedents</bookmark_value>
+ <bookmark_value>formula cells;tracing precedents</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowPrecedents" id="bm_id3145673"
localize="false"/>
-<h1 id="hd_id3155628"><link href="text/scalc/01/06030100.xhp">Trace
Precedents</link></h1>
-<paragraph role="paragraph" id="par_id3153542" xml-lang="en-US"><ahelp
hid=".uno:ShowPrecedents">This function shows the relationship between the
current cell containing a formula and the cells used in the
formula.</ahelp></paragraph>
+<bookmark branch="hid/.uno:ShowPrecedents" id="bm_id3145673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-ShowPrecedents"
id="bm_id651704575032384" localize="false"/>
+<section id="trace_precedents">
+ <h1 id="hd_id3155628"><link href="text/scalc/01/06030100.xhp">Trace
Precedents</link></h1>
+ <paragraph role="paragraph" id="par_id3153542"><ahelp
hid=".uno:ShowPrecedents">This function shows the relationship between the
current cell containing a formula and the cells used in the
formula.</ahelp></paragraph>
</section>
-<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US">Traces are
displayed in the sheet with marking arrows. At the same time, the range of all
the cells contained in the formula of the current cell is highlighted with a
blue frame.</paragraph>
+<paragraph role="paragraph" id="par_id3147265">Traces are displayed in the
sheet with marking arrows. At the same time, the range of all the cells
contained in the formula of the current cell is highlighted with a blue
frame.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#trace_precedents"/>
</section>
-<paragraph role="note" id="par_id3154321" xml-lang="en-US">This function is
based on a principle of layers. For example, if the precedent cell to a formula
is already indicated with a tracer arrow, when you repeat this command, the
tracer arrows are drawn to the precedent cells of this cell.</paragraph>
+<note id="par_id3154321">This function is based on a principle of layers. For
example, if the precedent cell to a formula is already indicated with a tracer
arrow, when you repeat this command, the tracer arrows are drawn to the
precedent cells of this cell.</note>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030200.xhp
b/source/text/scalc/01/06030200.xhp
index 587ea1bd6e..98bf4fc520 100644
--- a/source/text/scalc/01/06030200.xhp
+++ b/source/text/scalc/01/06030200.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="textscalc0106030200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Remove Precedents</title>
+<title id="tit">Remove Precedents</title>
<filename>/text/scalc/01/06030200.xhp</filename>
</topic>
<history>
@@ -30,16 +27,20 @@
</history>
</meta>
<body>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuTools-ClearArrowPrecedents"
id="bm_id501704575606513" localize="false"/>
+<bookmark branch="index" id="bm_id3155628"><bookmark_value>cells; removing
precedents</bookmark_value>
+ <bookmark_value>formula cells;removing precedents</bookmark_value>
+ </bookmark><comment>mw changed "formula..." entry</comment>
+<bookmark branch="hid/.uno:ClearArrowPrecedents" id="bm_id8005825"
localize="false"/>
<section id="remove_precedents">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3155628"><bookmark_value>cells; removing precedents</bookmark_value>
-<bookmark_value>formula cells;removing precedents</bookmark_value>
-</bookmark><comment>mw changed "formula..." entry</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:ClearArrowPrecedents"
id="bm_id8005825" localize="false"/>
-<h1 id="hd_id3155628"><link href="text/scalc/01/06030200.xhp">Remove
Precedents</link></h1>
-<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp
hid=".uno:ClearArrowPrecedents">Deletes one level of the trace arrows that were
inserted with the <emph>Trace Precedents</emph> command.</ahelp></paragraph>
+ <h1 id="hd_id3155628"><link href="text/scalc/01/06030200.xhp">Remove
Precedents</link></h1>
+ <paragraph role="paragraph" id="par_id3149456"><ahelp
hid=".uno:ClearArrowPrecedents">Deletes one level of the trace arrows that were
inserted with the <emph>Trace Precedents</emph> command.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#exdvore"/>
+ <embed href="text/scalc/00/00000406.xhp#remove_precedents"/>
+</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030300.xhp
b/source/text/scalc/01/06030300.xhp
index 5ae0a69372..d41c6e9ca0 100644
--- a/source/text/scalc/01/06030300.xhp
+++ b/source/text/scalc/01/06030300.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -21,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0106030300xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Trace Dependents</title>
+<title id="tit">Trace Dependents</title>
<filename>/text/scalc/01/06030300.xhp</filename>
</topic>
<history>
@@ -29,19 +27,20 @@
</history>
</meta>
<body>
-
-
- <section id="trace_dependents">
- <bookmark xml-lang="en-US" branch="index"
id="bm_id3153252"><bookmark_value>cells; tracing
dependents</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:ShowDependents" xml-lang="en-US" id="bm_id3143267"
localize="false"/>
-<h1 id="hd_id3153252"><link href="text/scalc/01/06030300.xhp">Trace
Dependents</link></h1>
- <paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><ahelp
hid=".uno:ShowDependents" visibility="visible">Draws tracer arrows to the
active cell from formulas that depend on values in the active
cell.</ahelp></paragraph>
- </section>
- <paragraph role="paragraph" id="par_id3148948" xml-lang="en-US">The area of
all cells that are used together with the active cell in a formula is
highlighted by a blue frame.</paragraph>
- <section id="howtoget">
+<section id="trace_dependents">
+ <bookmark branch="index" id="bm_id3153252"><bookmark_value>cells; tracing
dependents</bookmark_value></bookmark>
+ <bookmark branch="hid/.uno:ShowDependents" id="bm_id3143267"
localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-ShowDependents"
id="bm_id471704576521947" localize="false"/>
+ <h1 id="hd_id3153252"><link href="text/scalc/01/06030300.xhp">Trace
Dependents</link></h1>
+ <paragraph role="paragraph" id="par_id3156024"><ahelp
hid=".uno:ShowDependents" visibility="visible">Draws tracer arrows to the
active cell from formulas that depend on values in the active
cell.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3148948">The area of all cells that are
used together with the active cell in a formula is highlighted by a blue
frame.</paragraph>
+<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#trace_dependents"/>
</section>
- <paragraph xml-lang="en-US" role="note" id="par_id3151112">This function
works per level. For instance, if one level of traces has already been
activated to show the precedents (or dependents), then you would see the next
dependency level by activating the <emph>Trace</emph> function
again.</paragraph>
-
- </body>
+<note id="par_id3151112">This function works per level. For instance, if one
level of traces has already been activated to show the precedents (or
dependents), then you would see the next dependency level by activating the
<emph>Trace</emph> function again.</note>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030400.xhp
b/source/text/scalc/01/06030400.xhp
index 56357f6528..78fd60c27d 100644
--- a/source/text/scalc/01/06030400.xhp
+++ b/source/text/scalc/01/06030400.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="textscalc0106030400xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Remove Dependents</title>
+<title id="tit">Remove Dependents</title>
<filename>/text/scalc/01/06030400.xhp</filename>
</topic>
<history>
@@ -30,16 +27,18 @@
</history>
</meta>
<body>
-
-
- <section id="remove_dependents">
- <bookmark xml-lang="en-US" branch="index"
id="bm_id3147335"><bookmark_value>cells; removing
dependents</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:ClearArrowDependents" xml-lang="en-US"
id="bm_id3148552" localize="false"/>
-<h1 id="hd_id3147335"><link href="text/scalc/01/06030400.xhp">Remove
Dependents</link></h1>
- <paragraph role="paragraph" id="par_id3148663" xml-lang="en-US"><ahelp
visibility="visible" hid=".uno:ClearArrowDependents">Deletes one level of
tracer arrows created with <emph>Trace Dependents</emph>.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#exdszne"/>
+<bookmark branch="index" id="bm_id3147335"><bookmark_value>cells; removing
dependents</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ClearArrowDependents" id="bm_id3148552"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuTools-ClearArrowDependents"
id="bm_id361704576652328" localize="false"/>
+<section id="remove_dependents">
+ <h1 id="hd_id3147335"><link href="text/scalc/01/06030400.xhp">Remove
Dependents</link></h1>
+ <paragraph role="paragraph" id="par_id3148663"><ahelp visibility="visible"
hid=".uno:ClearArrowDependents">Deletes one level of tracer arrows created with
<emph>Trace Dependents</emph>.</ahelp></paragraph>
</section>
- </body>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000406.xhp#remove_dependents"/>
+</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030500.xhp
b/source/text/scalc/01/06030500.xhp
index d464a37f50..2d4a16c2f2 100644
--- a/source/text/scalc/01/06030500.xhp
+++ b/source/text/scalc/01/06030500.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="textscalc0106030500xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Remove All Traces</title>
+<title id="tit">Remove All Traces</title>
<filename>/text/scalc/01/06030500.xhp</filename>
</topic>
<history>
@@ -30,16 +27,18 @@
</history>
</meta>
<body>
-
-
- <section id="remove_all_traces">
- <bookmark xml-lang="en-US" branch="index"
id="bm_id3153088"><bookmark_value>cells; removing
traces</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:ClearArrows" xml-lang="en-US" id="bm_id3153541"
localize="false"/>
-<h1 id="hd_id3153088"><link href="text/scalc/01/06030500.xhp">Remove All
Traces</link></h1>
- <paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><ahelp
hid=".uno:ClearArrows" visibility="visible">Removes all tracer arrows from the
spreadsheet.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#exdase"/>
+<bookmark branch="index" id="bm_id3153088"><bookmark_value>cells; removing
traces</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ClearArrows" id="bm_id3153541" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-ClearArrows"
id="bm_id691704577222626" localize="false"/>
+<section id="remove_all_traces">
+ <h1 id="hd_id3153088"><link href="text/scalc/01/06030500.xhp">Remove All
Traces</link></h1>
+ <paragraph role="paragraph" id="par_id3151246"><ahelp hid=".uno:ClearArrows"
visibility="visible">Removes all tracer arrows from the
spreadsheet.</ahelp></paragraph>
</section>
- </body>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000406.xhp#remove_all"/>
+</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030600.xhp
b/source/text/scalc/01/06030600.xhp
index 753d307419..4c934231ab 100644
--- a/source/text/scalc/01/06030600.xhp
+++ b/source/text/scalc/01/06030600.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="textscalc0106030600xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Trace Error</title>
+<title id="tit">Trace Error</title>
<filename>/text/scalc/01/06030600.xhp</filename>
</topic>
<history>
@@ -30,16 +27,18 @@
</history>
</meta>
<body>
-
-
- <section id="trace_error">
- <bookmark branch="index" xml-lang="en-US"
id="bm_id3153561"><bookmark_value>cells; tracing
errors</bookmark_value><bookmark_value>tracing
errors</bookmark_value><bookmark_value>error tracing</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:ShowErrors" xml-lang="en-US" id="bm_id3153541"
localize="false"/>
-<h1 id="hd_id3153561"><link href="text/scalc/01/06030600.xhp">Trace
Error</link></h1>
- <paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp
hid=".uno:ShowErrors" visibility="visible">Draws tracer arrows to all precedent
cells which cause an error value in a selected cell.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#exdszfe"/>
+<bookmark branch="index" id="bm_id3153561"><bookmark_value>cells; tracing
errors</bookmark_value><bookmark_value>tracing
errors</bookmark_value><bookmark_value>error tracing</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ShowErrors" id="bm_id3153541" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-ShowErrors"
id="bm_id131704578452764" localize="false"/>
+<section id="trace_error">
+ <h1 id="hd_id3153561"><link href="text/scalc/01/06030600.xhp">Trace
Error</link></h1>
+ <paragraph role="paragraph" id="par_id3148550"><ahelp hid=".uno:ShowErrors"
visibility="visible">Draws tracer arrows to all precedent cells which cause an
error value in a selected cell.</ahelp></paragraph>
</section>
- </body>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000406.xhp#trace_errors"/>
+</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030700.xhp
b/source/text/scalc/01/06030700.xhp
index 3a0770ac42..b38b4bc59a 100644
--- a/source/text/scalc/01/06030700.xhp
+++ b/source/text/scalc/01/06030700.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="textscalc0106030700xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Fill Mode</title>
+<title id="tit">Fill Mode</title>
<filename>/text/scalc/01/06030700.xhp</filename>
</topic>
<history>
@@ -30,17 +27,21 @@
</history>
</meta>
<body>
-<section id="fill_mode">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3145119"><bookmark_value>cells; trace fill mode</bookmark_value>
-<bookmark_value>traces; precedents for multiple cells</bookmark_value>
+<bookmark branch="index" id="bm_id3145119"><bookmark_value>cells; trace fill
mode</bookmark_value>
+ <bookmark_value>traces; precedents for multiple cells</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:AuditingFillMode"
id="bm_id3148491" localize="false"/>
-<h1 id="hd_id3145119"><link href="text/scalc/01/06030700.xhp">Fill
Mode</link></h1>
-<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><ahelp
hid=".uno:AuditingFillMode">Activates the Fill Mode in the Detective. The mouse
pointer changes to a special symbol, and you can click any cell to see a trace
to the precedent cell.</ahelp> To exit this mode, press Escape or click the
<emph>End Fill Mode</emph> command in the context menu.</paragraph>
+<bookmark branch="hid/.uno:AuditingFillMode" id="bm_id3148491"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-AuditingFillMode"
id="bm_id751704579105460" localize="false"/>
+<section id="fill_mode">
+ <h1 id="hd_id3145119"><link href="text/scalc/01/06030700.xhp">Fill
Mode</link></h1>
+ <paragraph role="paragraph" id="par_id3151246"><ahelp
hid=".uno:AuditingFillMode">Activates the Fill Mode in the Detective. The mouse
pointer changes to a special symbol, and you can click any cell to see a trace
to the precedent cell.</ahelp> To exit this mode, press Escape or click the
<emph>Exit Fill Mode</emph> command in the context menu.</paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#fuellmodus"/>
+ <embed href="text/scalc/00/00000406.xhp#fill_mode"/>
+</section>
+<paragraph role="paragraph" id="par_id3151211">The <emph>Fill Mode</emph>
function is identical to the <link href="text/scalc/01/06030100.xhp">Trace
Precedent</link> command if you call this mode for the first time. Use the
context menu to select further options for the Fill Mode and to exit this
mode.</paragraph>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
</section>
-<paragraph role="paragraph" id="par_id3151211" xml-lang="en-US">The <emph>Fill
Mode</emph> function is identical to the <link
href="text/scalc/01/06030100.xhp">Trace Precedent</link> command if you call
this mode for the first time. Use the context menu to select further options
for the Fill Mode and to exit this mode.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030800.xhp
b/source/text/scalc/01/06030800.xhp
index 27710674ce..a109848ae1 100644
--- a/source/text/scalc/01/06030800.xhp
+++ b/source/text/scalc/01/06030800.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="textscalc0106030800xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Mark Invalid Data</title>
+<title id="tit">Mark Invalid Data</title>
<filename>/text/scalc/01/06030800.xhp</filename>
</topic>
<history>
@@ -30,17 +27,19 @@
</history>
</meta>
<body>
-
-
- <section id="mark_invalid_data">
- <bookmark branch="index" xml-lang="en-US"
id="bm_id3153821"><bookmark_value>cells; invalid
data</bookmark_value><bookmark_value>data; showing invalid
data</bookmark_value><bookmark_value>invalid
data;marking</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:ShowInvalid" xml-lang="en-US" id="bm_id3157909"
localize="false"/>
-<h1 id="hd_id3153821"><link href="text/scalc/01/06030800.xhp">Mark Invalid
Data</link></h1>
- <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp
hid=".uno:ShowInvalid" visibility="visible">Marks all cells in the sheet that
contain values outside the validation rules.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#dateneinkreisen"/>
+<bookmark branch="index" id="bm_id3153821"><bookmark_value>cells; invalid
data</bookmark_value><bookmark_value>data; showing invalid
data</bookmark_value><bookmark_value>invalid
data;marking</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ShowInvalid" id="bm_id3157909" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-ShowInvalid"
id="bm_id151704580056032" localize="false"/>
+<section id="mark_invalid_data">
+ <h1 id="hd_id3153821"><link href="text/scalc/01/06030800.xhp">Mark Invalid
Data</link></h1>
+ <paragraph role="paragraph" id="par_id3147264"><ahelp hid=".uno:ShowInvalid"
visibility="visible">Marks all cells in the sheet that contain values outside
the validation rules.</ahelp></paragraph>
</section>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3151211">The <link
href="text/scalc/01/12120000.xhp">validity rules</link> restrict the input of
numbers, dates, time values and text to certain values. However, it is possible
to enter invalid values or copy invalid values into the cells if the
<emph>Stop</emph> option is not selected. When you assign a validity rule,
existing values in a cell will not be modified.</paragraph>
- </body>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000406.xhp#mark_invalid_data"/>
+</section>
+<paragraph role="paragraph" id="par_id3151211">The <link
href="text/scalc/01/12120000.xhp">validity rules</link> restrict the input of
numbers, dates, time values and text to certain values. However, it is possible
to enter invalid values or copy invalid values into the cells if the
<emph>Stop</emph> option is not selected. When you assign a validity rule,
existing values in a cell will not be modified.</paragraph>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/06030900.xhp
b/source/text/scalc/01/06030900.xhp
index f0d7576292..86930a5fcb 100644
--- a/source/text/scalc/01/06030900.xhp
+++ b/source/text/scalc/01/06030900.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="textscalc0106030900xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Refresh Traces</title>
+<title id="tit">Refresh Traces</title>
<filename>/text/scalc/01/06030900.xhp</filename>
</topic>
<history>
@@ -30,29 +27,33 @@
</history>
</meta>
<body>
+<bookmark branch="index" id="bm_id3152349"><bookmark_value>cells; refreshing
traces</bookmark_value>
+ <bookmark_value>traces; refreshing</bookmark_value>
+ <bookmark_value>updating;traces</bookmark_value>
+ </bookmark><comment>mw made "updating..." a two level entry</comment>
+<bookmark branch="hid/.uno:RefreshArrows" id="bm_id9951902" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-RefreshArrows"
id="bm_id911704580386563" localize="false"/>
<section id="spurenaktualisieren">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3152349"><bookmark_value>cells; refreshing traces</bookmark_value>
-<bookmark_value>traces; refreshing</bookmark_value>
-<bookmark_value>updating;traces</bookmark_value>
-</bookmark><comment>mw made "updating..." a two level entry</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:RefreshArrows" id="bm_id9951902"
localize="false"/>
-<h1 id="hd_id3152349"><link href="text/scalc/01/06030900.xhp">Refresh
Traces</link></h1>
-<paragraph role="paragraph" id="par_id3148947" xml-lang="en-US"><ahelp
hid=".uno:RefreshArrows">Redraws all traces in the sheet. Formulas modified
when traces are redrawn are taken into account.</ahelp></paragraph>
+ <h1 id="hd_id3152349"><link href="text/scalc/01/06030900.xhp">Refresh
Traces</link></h1>
+ <paragraph role="paragraph" id="par_id3148947"><ahelp
hid=".uno:RefreshArrows">Redraws all traces in the sheet. Formulas modified
when traces are redrawn are taken into account.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#spurenaktualisieren"/>
+ <embed href="text/scalc/00/00000406.xhp#refresh_traces"/>
</section>
<section id="arrows">
-<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US">Detective
arrows in the document are updated under the following
circumstances:</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="listitem" id="par_id3153192" xml-lang="en-US">Starting
<emph>Tools - Detective - Update Refresh Traces</emph>
-</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3151041" xml-lang="en-US">If <emph>Tools
- Detective - AutoRefresh</emph> is turned on, every time formulas are changed
in the document.</paragraph>
-</listitem>
-</list>
+ <paragraph role="paragraph" id="par_id3148798">Detective arrows in the
document are updated under the following circumstances:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph role="listitem" id="par_id3153192">Starting <emph>Tools -
Detective - Update Refresh Traces</emph>
+ </paragraph>
+ </listitem>
+ <listitem>
+ <paragraph role="listitem" id="par_id3151041">If <emph>Tools - Detective
- AutoRefresh</emph> is turned on, every time formulas are changed in the
document.</paragraph>
+ </listitem>
+ </list>
+</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06031000.xhp
b/source/text/scalc/01/06031000.xhp
index f7742f149e..3f94c996c8 100644
--- a/source/text/scalc/01/06031000.xhp
+++ b/source/text/scalc/01/06031000.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="textscalc0106031000xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">AutoRefresh</title>
+<title id="tit">AutoRefresh</title>
<filename>/text/scalc/01/06031000.xhp</filename>
</topic>
<history>
@@ -30,17 +27,19 @@
</history>
</meta>
<body>
-
-
- <section id="autorefresh">
- <bookmark branch="index" xml-lang="en-US"
id="bm_id3154515"><bookmark_value>cells; autorefreshing
traces</bookmark_value><bookmark_value>traces;
autorefreshing</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:AutoRefreshArrows" xml-lang="en-US"
id="bm_id3153821" localize="false"/>
-<h1 id="hd_id3154515"><link
href="text/scalc/01/06031000.xhp">AutoRefresh</link></h1>
- <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp
hid=".uno:AutoRefreshArrows" visibility="visible">Automatically refreshes all
the traces in the sheet whenever you modify a formula.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#automatisch"/>
+<bookmark branch="index" id="bm_id3154515"><bookmark_value>cells;
autorefreshing traces</bookmark_value><bookmark_value>traces;
autorefreshing</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:AutoRefreshArrows" id="bm_id3153821"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuTools-AutoRefreshArrows"
id="bm_id111704580752475" localize="false"/>
+<section id="autorefresh">
+ <h1 id="hd_id3154515"><link
href="text/scalc/01/06031000.xhp">AutoRefresh</link></h1>
+ <paragraph role="paragraph" id="par_id3147264"><ahelp
hid=".uno:AutoRefreshArrows" visibility="visible">Automatically refreshes all
the traces in the sheet whenever you modify a formula.</ahelp></paragraph>
</section>
- <embed href="text/scalc/01/06030900.xhp#arrows"/>
- </body>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000406.xhp#auto_refresh"/>
+</section>
+<embed href="text/scalc/01/06030900.xhp#arrows"/>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id821704581444268"
localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
</helpdocument>
