source/text/scalc/01/04070100.xhp | 8 ++++++--
source/text/scalc/02/06010000.xhp | 19 +++++++++++++++----
source/text/scalc/04/01020000.xhp | 2 +-
source/text/scalc/main0206.xhp | 2 +-
4 files changed, 23 insertions(+), 8 deletions(-)
New commits:
commit 12e13425715a23ff426715e0bb7248d4aea55be9
Author: Dione Maddern <dionemadd...@gmail.com>
AuthorDate: Fri May 24 16:19:53 2024 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun May 26 23:14:32 2024 +0200
tdf#129097 Fix inconsistent names for Name Box/Sheet Area Box
In text/scalc/01/04070100.xhp
- Added variable tags to H1 to allow the page to be more easily linked from
other pages
- Updated reference to "Sheet Area" to read "Name Box" instead
In text/scalc/02/06010000.xhp
- Added index bookmarks to make the page easier to find
- Added a hid bookmark so that pressing F1 opens this page when the Name
Box is selected in Calc
- Added variable tags to H1 to allow the page to be more easily linked from
other pages
- Added variable tags to name in syname_box so it can be embedded in other
pages. Changes to the menu option will update the name in linked pages.
- Added a Related Topics Section
In source/text/scalc/04/01020000.xhp
- Replaced reference to "Sheet Area" with an embedded link to
text/scalc/02/06010000.xhp
In source/text/scalc/main0206.xhp
- Replaced reference to "Sheet Area" with an embedded link to
text/scalc/02/06010000.xhp
Change-Id: Iddd26877397f3ffcf7ee38b95c38550f1a216d87
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167947
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04070100.xhp
b/source/text/scalc/01/04070100.xhp
index 5d03d25b26..715c93403e 100644
--- a/source/text/scalc/01/04070100.xhp
+++ b/source/text/scalc/01/04070100.xhp
@@ -32,7 +32,7 @@
<bookmark branch="hid/modules/scalc/ui/definename/@@nowidget@@"
id="bm_id3155922" localize="false"/>
<section id="definenames">
- <h1 id="hd_id3156330"><link href="text/scalc/01/04070100.xhp">Define
Names</link></h1>
+ <h1 id="hd_id3156330"><variable id="define_names_h1"><link
href="text/scalc/01/04070100.xhp">Define Names</link></variable></h1>
<paragraph role="paragraph" id="par_id3154366"><variable
id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you
can specify a name for a selected area or a name for a formula
expression.</ahelp></variable></paragraph>
</section>
@@ -40,7 +40,7 @@
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#define_name"/>
</section>
-<paragraph role="paragraph" id="par_id3155131">The <emph>Sheet Area</emph> box
on the Formula bar contains a list of defined names for the ranges or formula
expressions and their scope between parenthesis. Click a name from this box to
highlight the corresponding reference on the spreadsheet. Names given formulas
or parts of a formula are not listed here.</paragraph>
+<paragraph role="paragraph" id="par_id3155131">The <menuitem>Name
Box</menuitem> box on the Formula bar contains a list of defined names for the
ranges or formula expressions and their scope between parenthesis. Click a name
from this box to highlight the corresponding reference on the spreadsheet.
Names given formulas or parts of a formula are not listed here.</paragraph>
<bookmark branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114"
localize="false"/>
<section id="h2name">
<h2 id="hd_id3151118">Name</h2>
@@ -84,5 +84,9 @@
<paragraph role="paragraph" id="par_id3159236"><ahelp hid=".">Click the
<emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
</section>
+<section id="relatedtopics">
+<embed href="text/scalc/02/06010000.xhp#name_box_h1"/>
+</section>
+
</body>
</helpdocument>
diff --git a/source/text/scalc/02/06010000.xhp
b/source/text/scalc/02/06010000.xhp
index cfc1b577c7..cb3f3d3cb2 100644
--- a/source/text/scalc/02/06010000.xhp
+++ b/source/text/scalc/02/06010000.xhp
@@ -30,23 +30,29 @@
</history>
</meta>
<body>
+
<section id="name_box">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3156326"><bookmark_value>formula bar; sheet area names</bookmark_value>
<bookmark_value>sheet area names</bookmark_value>
<bookmark_value>showing; cell references</bookmark_value>
<bookmark_value>cell references; showing</bookmark_value>
+<bookmark_value>sheet area; name box</bookmark_value>
+<bookmark_value>name box; sheet area</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_POS" id="bm_id3153087"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:FocusCellAddress"
id="bm_id2941984" localize="false"/>
-<h1 id="hd_id3156326"><link href="text/scalc/02/06010000.xhp">Name
Box</link></h1>
-<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp
hid="HID_INSWIN_POS">Displays the reference for the current cell, the range of
the selected cells, or the name of the area. You can also select a range of
cells, and then type a name for that range into the <emph>Name
Box</emph>.</ahelp><comment>UFI: fixes #i28238#</comment></paragraph>
+<bookmark branch="hid/modules/scalc/ui/posbox/pos_window"
id="bm_id83656515800315" localize="false"/>
+
+ <h1 id="hd_id3156326"><variable id="name_box_h1"><link
href="text/scalc/02/06010000.xhp">Name Box</link></variable></h1>
+<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp
hid="HID_INSWIN_POS">Displays the reference for the current cell, the range of
the selected cells, or the name of the area. You can also select a range of
cells, and then type a name for that range into the <emph>Name
Box</emph>.</ahelp></paragraph>
</section>
+
<section id="syname_box">
<table id="tbl_id3150870">
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3163710" xml-lang="en-US">
-<image id="img_id3152576" src="media/helpimg/calcein.png" width="1.2398inch"
height="0.2398inch" localize="true"><alt id="alt_id3152576"
xml-lang="en-US">Combo box sheet area</alt>
+<image id="img_id3152576" src="media/helpimg/calcein.png" width="1.2398inch"
height="0.2398inch" localize="true"><alt id="alt_id3152576"
xml-lang="en-US">Combo box name box</alt>
</image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
@@ -54,8 +60,13 @@
</tablecell>
</tablerow>
</table>
-
</section>
+
<paragraph role="paragraph" id="par_id3152596" xml-lang="en-US">To jump to a
particular cell, or to select a cell range, type the cell reference, or cell
range reference in this box, for example, F1, or A1:C4. You can also enter full
name of a sheet; the tooltip then changes to "Go To Sheet", and pressing Enter
switches to that sheet.</paragraph>
+
+<section id="relatedtopics">
+<embed href="text/scalc/01/04070100.xhp#define_names_h1"/>
+<embed href="text/scalc/main0206.xhp#formula_bar_h1"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/04/01020000.xhp
b/source/text/scalc/04/01020000.xhp
index 4da36a3795..1f13810706 100644
--- a/source/text/scalc/04/01020000.xhp
+++ b/source/text/scalc/04/01020000.xhp
@@ -437,7 +437,7 @@
<paragraph role="tablecontent" id="hd_id3150568"
xml-lang="en-US">Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F5</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153551"
xml-lang="en-US">Moves the cursor from the <emph>Input line</emph> to the
<emph>Sheet area</emph> box. You can also use Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+T.</paragraph>
+ <paragraph role="tablecontent" id="par_id3153551"
xml-lang="en-US">Moves the cursor from the <emph>Input line</emph> to the
<menuitem>Name Box</menuitem> box. You can also use Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+T.</paragraph>
</tablecell>
</tablerow>
<tablerow>
diff --git a/source/text/scalc/main0206.xhp b/source/text/scalc/main0206.xhp
index 18190fe0d1..bb68fa86b0 100644
--- a/source/text/scalc/main0206.xhp
+++ b/source/text/scalc/main0206.xhp
@@ -30,7 +30,7 @@
<section id="formula_bar">
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_INPUTWIN" id="bm_id3154347"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:FocusInputLine" id="bm_id7657094"
localize="false"/>
-<h1 id="hd_id3147264"><link href="text/scalc/main0206.xhp">Formula
Bar</link></h1>
+<h1 id="hd_id3147264"><variable id="formula_bar_h1"><link
href="text/scalc/main0206.xhp">Formula Bar</link></variable></h1>
<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp
hid="HID_SC_INPUTWIN">Use this bar to enter formulas.</ahelp></paragraph>
</section>
<embed href="text/scalc/02/06010000.xhp#name_box"/>
