summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGabor Kelemen <kelemeng@gnome.hu>2016-12-31 15:03:34 +0100
committerGabor Kelemen <kelemeng@ubuntu.com>2016-12-31 14:21:13 +0000
commit92e858687cb974b9f6074e9643f5377f24eb73a0 (patch)
tree1e47e90871dbcf7eb77ffc7c641fe7b40ffd7a64
parent5063054f398d3d354ac215cdae56492f5450ad98 (diff)
tdf#98643 Fix links between UI and the 'Define Names' page
So that they work in the Manage Names dialog too. Fixed up the text as well a bit to better fit the current state of the windows. I can't decide yet if it would be better to create a new Manage Names page or to change this one to mention Manage Names more (in title, howtoget, etc.) Change-Id: I5f39b02c54ccebde723b6b8b61bf7e58cd054028 Reviewed-on: https://gerrit.libreoffice.org/32536 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
-rw-r--r--source/text/scalc/01/04070100.xhp29
1 files changed, 17 insertions, 12 deletions
diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp
index a2197f0ad..6c1ccbb34 100644
--- a/source/text/scalc/01/04070100.xhp
+++ b/source/text/scalc/01/04070100.xhp
@@ -41,40 +41,45 @@
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115" localize="false"/>
<paragraph role="heading" id="hd_id3151118" xml-lang="en-US" level="2" l10n="U" oldref="3">Name</paragraph>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US" l10n="U" oldref="29"><ahelp hid="modules/scalc/ui/definename/edit">Enter the name of the area for which you want to define a reference or a formula expression. All area names already defined in the spreadsheet are listed in the text field below.</ahelp> If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph>
+<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US" l10n="U" oldref="29"><ahelp hid=".">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751" localize="false"/>
<paragraph role="heading" id="hd_id3153728" xml-lang="en-US" level="2" l10n="U" oldref="9">Range or formula expression</paragraph>
-<paragraph role="paragraph" id="par_id3147435" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="modules/scalc/ui/definename/range">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147435" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid=".">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3146986" xml-lang="en-US" l10n="U" oldref="12">To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression.</paragraph>
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/more" id="bm_id3148455" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148456" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456" localize="false"/>
<paragraph role="heading" id="hd_id31547290" xml-lang="en-US" level="2" l10n="U" oldref="13">Scope</paragraph>
-<paragraph role="paragraph" id="hd_id31547291" xml-lang="en-US" level="2" l10n="U" oldref="13">Select the scope of the named range or named formula. Document(Global) means the name is valid for the whole document. Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph>
+<paragraph role="paragraph" id="hd_id31547291" xml-lang="en-US" level="2" l10n="U" oldref="13"><ahelp hid=".">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458" localize="false"/>
<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="2" l10n="U" oldref="13">Range options</paragraph>
-<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="modules/scalc/ui/definename/more">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3155416" xml-lang="en-US" l10n="U" oldref="16">Defines additional options related to the type of reference area.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/printarea" id="bm_id3146972" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973" localize="false"/>
<paragraph role="heading" id="hd_id3150716" xml-lang="en-US" level="4" l10n="U" oldref="17">Print range</paragraph>
-<paragraph role="paragraph" id="par_id3150751" xml-lang="en-US" l10n="U" oldref="18"><ahelp hid="modules/scalc/ui/definename/printarea">Defines the area as a print range.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150751" xml-lang="en-US" l10n="U" oldref="18"><ahelp hid=".">Defines the area as a print range.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/filter" id="bm_id3155446" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447" localize="false"/>
<paragraph role="heading" id="hd_id3153764" xml-lang="en-US" level="4" l10n="U" oldref="19">Filter</paragraph>
-<paragraph role="paragraph" id="par_id3155766" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="modules/scalc/ui/definename/filter">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp" name="advanced filter">advanced filter</link>.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155766" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid=".">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp" name="advanced filter">advanced filter</link>.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/colheader" id="bm_id3147344" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345" localize="false"/>
<paragraph role="heading" id="hd_id3159267" xml-lang="en-US" level="4" l10n="U" oldref="21">Repeat column</paragraph>
-<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="22"><ahelp hid="modules/scalc/ui/definename/colheader">Defines the area as a repeating column.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="22"><ahelp hid=".">Defines the area as a repeating column.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/rowheader" id="bm_id3154021" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022" localize="false"/>
<paragraph role="heading" id="hd_id3153966" xml-lang="en-US" level="4" l10n="U" oldref="23">Repeat row</paragraph>
-<paragraph role="paragraph" id="par_id3150300" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="modules/scalc/ui/definename/rowheader">Defines the area as a repeating row.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150300" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid=".">Defines the area as a repeating row.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/add" id="bm_id3150208" localize="false"/>
-<paragraph role="heading" id="hd_id3155112" xml-lang="en-US" level="2" l10n="U" oldref="27">Add/Modify</paragraph>
-<paragraph role="paragraph" id="par_id3159236" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid="modules/scalc/ui/managenamesdialog/add">Click the <emph>Add</emph> button to add the defined name to the list. Click the <emph>Modify</emph> button to enter another name for an already existing name selected from the list.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3155112" xml-lang="en-US" level="2" l10n="U" oldref="27">Add</paragraph>
+<paragraph role="paragraph" id="par_id3159236" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid=".">Click the <emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209" localize="false"/>
<embed href="text/shared/00/00000001.xhp#loeschen"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/names" id="bm_id3150210" localize="false"/>
+<paragraph role="paragraph" id="par_id3150301" xml-lang="en-US"><ahelp hid="modules/scalc/ui/managenamesdialog/names" visibility="hidden">Select a named range or named formula from the list to modify its properties.</ahelp></paragraph>
</body>
</helpdocument>