summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2015-04-23 19:15:11 -0300
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2015-04-23 23:21:24 +0000
commit2de16592c759d264acc3a546fc10102cd592fe0a (patch)
treebac0876740d70e363da77a5233bcb5c126ead9d8
parent7e67bfc7ab1f013826154d1fef66cbcfc3d92892 (diff)
tdf#90782 Adjust help page for new named formula
Adjust the help page after change in Calc Define Name dialog. Add explanation about "scope". Change-Id: Id3e0b3a2a6f1af8013811264a28ece21610d8370 Reviewed-on: https://gerrit.libreoffice.org/15501 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
-rw-r--r--source/text/scalc/01/04070100.xhp23
1 files changed, 12 insertions, 11 deletions
diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp
index 7978160eea..a2197f0ad1 100644
--- a/source/text/scalc/01/04070100.xhp
+++ b/source/text/scalc/01/04070100.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,8 +18,8 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
+
+
<meta>
<topic id="textscalc0104070100xml" indexer="include">
<title id="tit" xml-lang="en-US">Define Names</title>
@@ -31,28 +31,29 @@
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/DefineNameDialog" id="bm_id3155922" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog" id="bm_id3155923" localize="false"/>
<paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="1" l10n="U" oldref="1">Define Names</paragraph>
-<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US" l10n="U" oldref="2"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you can specify a name for a selected area.</ahelp>
+<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US" l10n="U" oldref="2"><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>
<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US" l10n="U" oldref="31">Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#einafe"/>
</section>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US" l10n="U" oldref="30">The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges. 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" xml-lang="en-US" l10n="U" oldref="30">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>
<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. 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="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>
<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">Assigned to</paragraph>
+<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_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.</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"/>
-<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="2" l10n="U" oldref="13">More</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="heading" id="hd_id3147394" xml-lang="en-US" level="3" l10n="U" oldref="15">Area type</paragraph>
+<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="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_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"/>