summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGabor Kelemen <kelemeng@gnome.hu>2016-12-06 21:42:53 +0100
committerCaolán McNamara <caolanm@redhat.com>2016-12-07 09:06:43 +0000
commiteb91fb0313b9e9f3b1276502aebf77ca8ff6c115 (patch)
treec991393df7b4ab47d01a6a472ae1e9bc768245db
parent75c62b4a8207e56c9998429a07760350badc9ded (diff)
tdf#104410 'Insert - Names' moved and renamed
Now this menu item is 'Sheet - Named Ranges and Expressions' Change-Id: I82113ef2e969cd2409fe114a51789e030752cdc0 Reviewed-on: https://gerrit.libreoffice.org/31700 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
-rw-r--r--source/text/scalc/00/00000404.xhp10
-rw-r--r--source/text/scalc/01/04060109.xhp4
-rw-r--r--source/text/scalc/01/04070000.xhp4
-rw-r--r--source/text/scalc/01/04070300.xhp2
-rw-r--r--source/text/scalc/01/05080300.xhp2
-rw-r--r--source/text/scalc/guide/cellreference_dragdrop.xhp4
-rw-r--r--source/text/scalc/guide/value_with_name.xhp6
-rw-r--r--source/text/shared/guide/hyperlink_insert.xhp2
8 files changed, 17 insertions, 17 deletions
diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index e2646da7d..55384c573 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -164,20 +164,20 @@
</variable></paragraph>
<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="33"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Names</emph>
+<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Named Ranges and Expressions</emph>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US" l10n="CHG" oldref="37"><variable id="eiextdata">Choose <emph>Sheet - Link to External data</emph>
</variable></paragraph>
<section id="einafe">
-<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Insert - Names - Define</emph>
+<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Sheet - Named Ranges and Expressions - Define</emph>
</paragraph>
<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US" l10n="U" oldref="35"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Insert - Names - Insert</emph>
+<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Sheet - Named Ranges and Expressions - Insert</emph>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Insert - Names - Create</emph>
+<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Sheet - Named Ranges and Expressions - Create</emph>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Insert - Names - Labels</emph>
+<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Sheet - Named Ranges and Expressions - Labels</emph>
</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 8c9688f76..109fbb42c 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -205,13 +205,13 @@
<paragraph xml-lang="en-US" id="par_id3159112" role="paragraph" l10n="U" oldref="56">
<item type="input">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150691" role="paragraph" l10n="U" oldref="57">
- <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names - Define</emph>.</paragraph>
+ <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>.</paragraph>
<paragraph xml-lang="en-US" id="par_id4109012" role="paragraph" l10n="NEW">
<item type="input">=INDEX(A1:B6;1)</item> returns a reference to the first row of A1:B6.</paragraph>
<paragraph xml-lang="en-US" id="par_id9272133" role="paragraph" l10n="NEW">
<item type="input">=INDEX(A1:B6;0;1)</item> returns a reference to the first column of A1:B6.</paragraph>
<paragraph xml-lang="en-US" id="par_id3158419" role="paragraph" l10n="U" oldref="58">
- <item type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Insert - Names - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>range</emph> parameter.</paragraph>
+ <item type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Sheet - Named Ranges and Expressions - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>range</emph> parameter.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148595" role="paragraph" l10n="U" oldref="59">
<item type="input">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range.</paragraph>
<paragraph xml-lang="en-US" id="par_id9960020" role="paragraph" l10n="NEW">
diff --git a/source/text/scalc/01/04070000.xhp b/source/text/scalc/01/04070000.xhp
index 4e6417963..5df801c50 100644
--- a/source/text/scalc/01/04070000.xhp
+++ b/source/text/scalc/01/04070000.xhp
@@ -22,7 +22,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0104070000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Names</title>
+<title id="tit" xml-lang="en-US">Named Ranges and Expressions</title>
<filename>/text/scalc/01/04070000.xhp</filename>
</topic>
<history>
@@ -32,7 +32,7 @@
<body>
<section id="namen">
<bookmark xml-lang="en-US" branch="hid/.uno:NamesMenu" id="bm_id2043214" localize="false"/>
-<paragraph role="heading" id="hd_id3153951" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/04070000.xhp" name="Names">Names</link></paragraph>
+<paragraph role="heading" id="hd_id3153951" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/04070000.xhp" name="Names">Named Ranges and Expressions</link></paragraph>
<paragraph role="paragraph" id="par_id3145801" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".">Allows you to name the different sections of your spreadsheet document.</ahelp> By naming the different sections, you can easily <link href="text/scalc/01/02110000.xhp" name="navigate">navigate</link> through the spreadsheet documents and find specific information.</paragraph>
</section>
<section id="howtoget">
diff --git a/source/text/scalc/01/04070300.xhp b/source/text/scalc/01/04070300.xhp
index be7275bd6..6e259a53b 100644
--- a/source/text/scalc/01/04070300.xhp
+++ b/source/text/scalc/01/04070300.xhp
@@ -41,7 +41,7 @@
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#einaueb"/>
</section>
-<paragraph role="paragraph" id="par_id3156280" xml-lang="en-US" l10n="U" oldref="13">Select the area containing all the ranges that you want to name. Then choose <emph>Insert - Names - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph>
+<paragraph role="paragraph" id="par_id3156280" xml-lang="en-US" l10n="U" oldref="13">Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph>
<paragraph role="heading" id="hd_id3151116" xml-lang="en-US" level="2" l10n="U" oldref="3">Create names from</paragraph>
<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US" l10n="U" oldref="4">Defines which part of the spreadsheet is to be used for creating the name.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/top" id="bm_id3156444" localize="false"/>
diff --git a/source/text/scalc/01/05080300.xhp b/source/text/scalc/01/05080300.xhp
index c564b7c1e..31c964d14 100644
--- a/source/text/scalc/01/05080300.xhp
+++ b/source/text/scalc/01/05080300.xhp
@@ -43,7 +43,7 @@
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edprintarea" id="bm_id3150447" localize="false"/>
<paragraph role="heading" id="hd_id3156281" xml-lang="en-US" level="2" l10n="U" oldref="3">Print range</paragraph>
<paragraph role="paragraph" id="par_id3147228" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="modules/scalc/ui/printareasdialog/edprintarea">Allows you to modify a defined print range.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3145174" xml-lang="en-US" l10n="CHG" oldref="5">Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Insert - Names - Define</emph> command, this name will be displayed and can be selected from the list box.</paragraph>
+<paragraph role="paragraph" id="par_id3145174" xml-lang="en-US" l10n="CHG" oldref="5">Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Sheet - Named Ranges and Expressions - Define</emph> command, this name will be displayed and can be selected from the list box.</paragraph>
<paragraph role="paragraph" id="par_id3145272" xml-lang="en-US" l10n="U" oldref="6">In the right-hand text box, you can enter a print range by reference or by name. If the cursor is in the <emph>Print range</emph> text box, you can also select the print range in the spreadsheet with your mouse.</paragraph>
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbrepeatrow" id="bm_id3147435" localize="false"/>
diff --git a/source/text/scalc/guide/cellreference_dragdrop.xhp b/source/text/scalc/guide/cellreference_dragdrop.xhp
index 6b4d0daa3..c4a839639 100644
--- a/source/text/scalc/guide/cellreference_dragdrop.xhp
+++ b/source/text/scalc/guide/cellreference_dragdrop.xhp
@@ -41,7 +41,7 @@
<paragraph xml-lang="en-US" id="par_id3152576" role="listitem" l10n="U" oldref="25">Open the document that contains the source cells.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3154011" role="listitem" l10n="U" oldref="26">To set the source range as the range, select the cells and choose <emph>Insert - Names - Define</emph>. Save the source document, and do not close it.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154011" role="listitem" l10n="U" oldref="26">To set the source range as the range, select the cells and choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. Save the source document, and do not close it.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3151073" role="listitem" l10n="U" oldref="18">Open the sheet in which you want to insert something.</paragraph>
@@ -65,4 +65,4 @@
<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/>
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp
index 3a5f7cb19..4a340e4e0 100644
--- a/source/text/scalc/guide/value_with_name.xhp
+++ b/source/text/scalc/guide/value_with_name.xhp
@@ -66,7 +66,7 @@
<paragraph xml-lang="en-US" id="par_id4889675" role="paragraph" l10n="NEW">Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names,</paragraph>
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id3153954" role="listitem" l10n="U" oldref="3">Select a cell or range of cells, then choose <emph>Insert - Names - Define</emph>. The <emph>Define Names</emph> dialog appears.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153954" role="listitem" l10n="U" oldref="3">Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3156283" role="listitem" l10n="U" oldref="4">Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog.</paragraph>
@@ -83,10 +83,10 @@
</listitem>
</list>
<section id="relatedtopics">
- <paragraph xml-lang="en-US" id="par_id3153711" role="paragraph" l10n="U" oldref="8"><link href="text/scalc/01/04070100.xhp" name="Insert - Names - Define">Insert - Names - Define</link></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153711" role="paragraph" l10n="U" oldref="8"><link href="text/scalc/01/04070100.xhp" name="Sheet - Named Ranges and Expressions - Define">Sheet - Named Ranges and Expressions - Define</link></paragraph>
<embed href="text/scalc/guide/goalseek.xhp#goalseek"/>
<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/>
<embed href="text/scalc/guide/address_auto.xhp#address_auto"/><comment>mw deleted one EMBED paragraph and copied two EMBED paragraphs from Calc guide address_byname.xhp</comment>
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/shared/guide/hyperlink_insert.xhp b/source/text/shared/guide/hyperlink_insert.xhp
index 239abb96c..1ad166346 100644
--- a/source/text/shared/guide/hyperlink_insert.xhp
+++ b/source/text/shared/guide/hyperlink_insert.xhp
@@ -42,7 +42,7 @@
<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="CHG" oldref="23">To jump to a specific line in a text document, first enter a bookmark at that position (<emph>Insert - Bookmark</emph>). </paragraph>
</listitem>
<listitem>
-<paragraph role="paragraph" id="par_idN1076D" xml-lang="en-US" l10n="NEW">To jump to a cell in a spreadsheet, first enter a name for the cell (<emph>Insert - Names - Define</emph>).</paragraph>
+<paragraph role="paragraph" id="par_idN1076D" xml-lang="en-US" l10n="NEW">To jump to a cell in a spreadsheet, first enter a name for the cell (<emph>Sheet - Named Ranges and Expressions - Define</emph>).</paragraph>
</listitem>
</list>
<paragraph role="tip" id="par_id3152887" xml-lang="en-US" l10n="U" oldref="24">Hyperlinks can also be inserted by drag-and-drop from the Navigator. Hyperlinks can refer to references, headings, graphics, tables, objects, directories or bookmarks.</paragraph>