source/text/scalc/00/00000404.xhp | 10 +++++-----
source/text/scalc/01/04060109.xhp | 4 ++--
source/text/scalc/01/04070000.xhp | 4 ++--
source/text/scalc/01/04070300.xhp | 2 +-
source/text/scalc/01/05080300.xhp | 2 +-
source/text/scalc/guide/cellreference_dragdrop.xhp | 4 ++--
source/text/scalc/guide/value_with_name.xhp | 6 +++---
source/text/shared/guide/hyperlink_insert.xhp | 2 +-
8 files changed, 17 insertions(+), 17 deletions(-)
New commits:
commit 38da3d11894b068011fe16030da50ebfdf7887b8
Author: Gabor Kelemen <kelem...@gnome.hu>
Date: Tue Dec 6 21:42:53 2016 +0100
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 <caol...@redhat.com>
Tested-by: Caolán McNamara <caol...@redhat.com>
(cherry picked from commit eb91fb0313b9e9f3b1276502aebf77ca8ff6c115)
Reviewed-on: https://gerrit.libreoffice.org/31742
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/00/00000404.xhp
b/source/text/scalc/00/00000404.xhp
index c8e3cce..ff759d2 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 8c9688f..109fbb4 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 4e64179..5df801c 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 be7275b..6e259a5 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 c564b7c..31c964d 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 6b4d0da..c4a8396 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 3a5f7cb..4a340e4 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 239abb9..1ad1663 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
