diff options
| author | Dione Maddern <dionemaddern@gmail.com> | 2024-05-24 16:19:53 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-05-26 23:14:32 +0200 |
| commit | 12e13425715a23ff426715e0bb7248d4aea55be9 (patch) | |
| tree | 4719cfe046ef6a3106aa1ec367c87e659ee84e56 /source | |
| parent | f26ce1d963abdd6d0503d2f225abc9423a77ccdd (diff) | |
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.hallot@libreoffice.org>
Tested-by: Jenkins
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04070100.xhp | 8 | ||||
| -rw-r--r-- | source/text/scalc/02/06010000.xhp | 19 | ||||
| -rw-r--r-- | source/text/scalc/04/01020000.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/main0206.xhp | 2 |
4 files changed, 23 insertions, 8 deletions
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"/> |