From 38da3d11894b068011fe16030da50ebfdf7887b8 Mon Sep 17 00:00:00 2001 From: Gabor Kelemen Date: Tue, 6 Dec 2016 21:42:53 +0100 Subject: tdf#104410 'Insert - Names' moved and renamed MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 Tested-by: Caolán McNamara (cherry picked from commit eb91fb0313b9e9f3b1276502aebf77ca8ff6c115) Reviewed-on: https://gerrit.libreoffice.org/31742 Reviewed-by: Adolfo Jayme Barrientos Tested-by: Adolfo Jayme Barrientos --- 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(-) (limited to 'source/text') diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp index c8e3cce6e1..ff759d2b6b 100644 --- a/source/text/scalc/00/00000404.xhp +++ b/source/text/scalc/00/00000404.xhp @@ -164,20 +164,20 @@ Choose Insert - Function List -Choose Insert - Names +Choose Insert - Named Ranges and Expressions Choose Sheet - Link to External Data
-Choose Insert - Names - Define +Choose Sheet - Named Ranges and Expressions - Define CommandCtrl+F3
-Choose Insert - Names - Insert +Choose Sheet - Named Ranges and Expressions - Insert -Choose Insert - Names - Create +Choose Sheet - Named Ranges and Expressions - Create -Choose Insert - Names - Labels +Choose Sheet - Named Ranges and Expressions - Labels diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 8c9688f768..109fbb42c2 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -205,13 +205,13 @@ =INDEX(Prices;4;1) returns the value from row 4 and column 1 of the database range defined in Data - Define as Prices. - =INDEX(SumX;4;1) returns the value from the range SumX in row 4 and column 1 as defined in Insert - Names - Define. + =INDEX(SumX;4;1) returns the value from the range SumX in row 4 and column 1 as defined in Sheet - Named Ranges and Expressions - Define. =INDEX(A1:B6;1) returns a reference to the first row of A1:B6. =INDEX(A1:B6;0;1) returns a reference to the first column of A1:B6. - =INDEX((multi);4;1) indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under Insert - Names - Define as multi. 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 2 as the range parameter. + =INDEX((multi);4;1) indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under Sheet - Named Ranges and Expressions - Define as multi. 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 2 as the range parameter. =INDEX(A1:B6;1;1) indicates the value in the upper-left of the A1:B6 range. diff --git a/source/text/scalc/01/04070000.xhp b/source/text/scalc/01/04070000.xhp index 4e64179636..5df801c505 100644 --- a/source/text/scalc/01/04070000.xhp +++ b/source/text/scalc/01/04070000.xhp @@ -22,7 +22,7 @@ -Names +Named Ranges and Expressions /text/scalc/01/04070000.xhp @@ -32,7 +32,7 @@
-Names +Named Ranges and Expressions Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.
diff --git a/source/text/scalc/01/04070300.xhp b/source/text/scalc/01/04070300.xhp index be7275bd66..6e259a53bd 100644 --- a/source/text/scalc/01/04070300.xhp +++ b/source/text/scalc/01/04070300.xhp @@ -41,7 +41,7 @@
-Select the area containing all the ranges that you want to name. Then choose Insert - Names - Create. This opens the Create Names dialog, from which you can select the naming options that you want. +Select the area containing all the ranges that you want to name. Then choose Sheet - Named Ranges and Expressions - Create. This opens the Create Names dialog, from which you can select the naming options that you want. Create names from Defines which part of the spreadsheet is to be used for creating the name. diff --git a/source/text/scalc/01/05080300.xhp b/source/text/scalc/01/05080300.xhp index c564b7c1e7..31c964d140 100644 --- a/source/text/scalc/01/05080300.xhp +++ b/source/text/scalc/01/05080300.xhp @@ -43,7 +43,7 @@ Print range Allows you to modify a defined print range. -Select -none- to remove a print range definition for the current spreadsheet. Select -entire sheet- to set the current sheet as a print range. Select -selection- to define the selected area of a spreadsheet as the print range. By selecting -user-defined-, you can define a print range that you have already defined using the Format - Print Ranges - Define command. If you have given a name to a range using the Insert - Names - Define command, this name will be displayed and can be selected from the list box. +Select -none- to remove a print range definition for the current spreadsheet. Select -entire sheet- to set the current sheet as a print range. Select -selection- to define the selected area of a spreadsheet as the print range. By selecting -user-defined-, you can define a print range that you have already defined using the Format - Print Ranges - Define command. If you have given a name to a range using the Sheet - Named Ranges and Expressions - Define command, this name will be displayed and can be selected from the list box. In the right-hand text box, you can enter a print range by reference or by name. If the cursor is in the Print range text box, you can also select the print range in the spreadsheet with your mouse. diff --git a/source/text/scalc/guide/cellreference_dragdrop.xhp b/source/text/scalc/guide/cellreference_dragdrop.xhp index 6b4d0daa33..c4a8396390 100644 --- a/source/text/scalc/guide/cellreference_dragdrop.xhp +++ b/source/text/scalc/guide/cellreference_dragdrop.xhp @@ -41,7 +41,7 @@ Open the document that contains the source cells. - To set the source range as the range, select the cells and choose Insert - Names - Define. Save the source document, and do not close it. + To set the source range as the range, select the cells and choose Sheet - Named Ranges and Expressions - Define. Save the source document, and do not close it. Open the sheet in which you want to insert something. @@ -65,4 +65,4 @@
- \ No newline at end of file + diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index 3a5f7cb196..4a340e4e00 100644 --- a/source/text/scalc/guide/value_with_name.xhp +++ b/source/text/scalc/guide/value_with_name.xhp @@ -66,7 +66,7 @@ Use the Define Names dialog to define names for formulas or parts of formulas you need more often. In order to specify range names, - Select a cell or range of cells, then choose Insert - Names - Define. The Define Names dialog appears. + Select a cell or range of cells, then choose Sheet - Named Ranges and Expressions - Define. The Define Names dialog appears. Type the name of the selected area in the Name field. Click Add. The newly defined name appears in the list below. Click OK to close the dialog. @@ -83,10 +83,10 @@
- Insert - Names - Define + Sheet - Named Ranges and Expressions - Define mw deleted one EMBED paragraph and copied two EMBED paragraphs from Calc guide address_byname.xhp
- \ No newline at end of file + diff --git a/source/text/shared/guide/hyperlink_insert.xhp b/source/text/shared/guide/hyperlink_insert.xhp index 239abb96c7..1ad1663468 100644 --- a/source/text/shared/guide/hyperlink_insert.xhp +++ b/source/text/shared/guide/hyperlink_insert.xhp @@ -42,7 +42,7 @@ To jump to a specific line in a text document, first enter a bookmark at that position (Insert - Bookmark). -To jump to a cell in a spreadsheet, first enter a name for the cell (Insert - Names - Define). +To jump to a cell in a spreadsheet, first enter a name for the cell (Sheet - Named Ranges and Expressions - Define). Hyperlinks can also be inserted by drag-and-drop from the Navigator. Hyperlinks can refer to references, headings, graphics, tables, objects, directories or bookmarks. -- cgit