diff options
author | Gabor Kelemen <kelemeng@gnome.hu> | 2016-12-31 15:03:34 +0100 |
---|---|---|
committer | Gabor Kelemen <kelemeng@ubuntu.com> | 2016-12-31 14:21:13 +0000 |
commit | 92e858687cb974b9f6074e9643f5377f24eb73a0 (patch) | |
tree | 1e47e90871dbcf7eb77ffc7c641fe7b40ffd7a64 /source/text/scalc | |
parent | 5063054f398d3d354ac215cdae56492f5450ad98 (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>
Diffstat (limited to 'source/text/scalc')
-rw-r--r-- | source/text/scalc/01/04070100.xhp | 29 |
1 files changed, 17 insertions, 12 deletions
diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp index a2197f0ad1..6c1ccbb34f 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> |