You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID> on 2019/03/20 00:48:41 UTC
Need to Edit the name Box definitions
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
Windows 10-x64 Home, DELL desktop.
_________________________________________
I have an AOO-Calc spreadsheet that has several "name box" definitions,
which I must revise or redefine the defined range. I have forgotten how
to define and / or edit the contents of the name box definitions. And,
I could not find info about "name box" in the Help (F1) file.
What I mean as the "name box" is the entry line with a down arrow that
is located to the left of the input line. This is the area that shows
the cell identification when a cell is selected/highlighted. In
otherwords, if I were to select the C60 cell in my spreadsheet, then C60
shows up in the name box area. If I position the mouse cursor in this
area, "Name Box" appears on screen.
Please help.
Regards,
VinceB.
Re: Need to Edit the name Box definitions
Posted by Brian Barker <b....@btinternet.com.INVALID>.
At 20:48 19/03/2019 -0400, Vince Bonly wrote:
>I have an AOO-Calc spreadsheet that has several "name box"
>definitions, which I must revise or redefine the defined range. I
>have forgotten how to define and / or edit the contents of the name
>box definitions. And, I could not find info about "name box" in the
>Help (F1) file. What I mean as the "name box" is the entry line with
>a down arrow that is located to the left of the input line. This is
>the area that shows the cell identification when a cell is
>selected/highlighted. In other words, if I were to select the C60
>cell in my spreadsheet, then C60 shows up in the name box area. If I
>position the mouse cursor in this area, "Name Box" appears on screen.
Yes, that drop-down menu box is called the Name Box, but the names
themselves are called just "names".
To define a name for a cell range:
o Select the range.
o Go to Insert | Names > | Define... .
o Enter a name.
o OK.
To delete a name:
o Go to Insert | Names > | Define... .
o Select the name.
o Delete.
o Yes.
o OK.
To modify the definition of a name:
o Go to Insert | Names > | Define... .
o Select the existing name.
o Drag across the new range.
o Modify.
o OK.
You could always modify any definition by deleting the existing one
and creating a new one in the same name, of course.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Need to Edit the name Box definitions
Posted by David Robley <ro...@gmail.com>.
For future reference, you can cut and paste a named range and the name
will move with the range.
On 22/3/19 7:47 am, WA.TWORSX via AOL wrote:
>
> On 3/19/2019 10:00 PM, Brian Barker wrote:
>> At 20:48 19/03/2019 -0400, Vince Bonly wrote:
>>> I have an AOO-Calc spreadsheet that has several "name box"
>>> definitions, which I must revise or redefine the defined range. I
>>> have forgotten how to define and / or edit the contents of the name
>>> box definitions. And, I could not find info about "name box" in the
>>> Help (F1) file. What I mean as the "name box" is the entry line with
>>> a down arrow that is located to the left of the input line. This is
>>> the area that shows the cell identification when a cell is
>>> selected/highlighted. In other words, if I were to select the C60
>>> cell in my spreadsheet, then C60 shows up in the name box area. If I
>>> position the mouse cursor in this area, "Name Box" appears on screen.
>>
>> Yes, that drop-down menu box is called the Name Box, but the names
>> themselves are called just "names".
>>
>> To define a name for a cell range:
>> o Select the range.
>> o Go to Insert | Names > | Define... .
>> o Enter a name.
>> o OK.
>
>> To delete a name:
>> o Go to Insert | Names > | Define... .
>> o Select the name.
>> o Delete.
>> o Yes.
>> o OK.
>>
>> To modify the definition of a name:
>> o Go to Insert | Names > | Define... .
>> o Select the existing name.
>> o Drag across the new range.
>> o Modify.
>> o OK.
>>
> Would liked to have had a "More" or "Continue" button here instead of
> clicking OK, etc.
>
>
>> You could always modify any definition by deleting the existing one
>> and creating a new one in the same name, of course.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
> Brian:
>
> Just to let you know that your suggestions / instructions workedout
> splendidily here, and to say TNX again. Certainly was helpful. I do
> wish, however, that there was a "More" or "Continue" button available,
> rather than needing to go back to step one. I had to change the Named
> Ranges for 13 columns that were shifted in the spreadsheet.
>
> Regards,
>
> VinceB.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Cheers
--
David Robley
Beam me up Scotty. This isn't the men's room.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Need to Edit the name Box definitions
Posted by Brian Barker <b....@btinternet.com.INVALID>.
At 17:17 21/03/2019 -0400, Vince Bonly wrote:
>On 3/19/2019 10:00 PM, Brian Barker wrote:
>>To modify the definition of a name:
>>o Go to Insert | Names > | Define... .
>>o Select the existing name.
>>o Drag across the new range.
>>o Modify.
>>o OK.
>
>Just to let you know that your suggestions / instructions worked out
>splendidly here, and to say TNX again. Certainly was helpful.
Good-oh! No probs!
>I do wish, however, that there was a "More" or "Continue" button
>available, rather than needing to go back to step one. I had to
>change the Named Ranges for 13 columns that were shifted in the spreadsheet.
That's easy, and there is no need for an extra button: just repeat
steps two, three, and four - Select, Drag, and Modify - as necessary,
before using OK once.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Need to Edit the name Box definitions
Posted by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID>.
>
>> I do wish, however, that there was a "More" or "Continue" button
>> available, rather than needing to go back to step one. I had to
>> change the Named Ranges for 13 columns that were shifted in the
>> spreadsheet.
>
> That's easy, and there is no need for an extra button: just repeat
> steps two, three, and four - Select, Drag, and Modify - as necessary,
> before using OK once.
>
> Brian Barker
>
>
>
I was not able to do that earlier, perhaps due to severally needing to
recover the file.
I will try again, using a PLAY-spreadsheet.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Need to Edit the name Box definitions
Posted by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID>.
On 3/19/2019 10:00 PM, Brian Barker wrote:
> At 20:48 19/03/2019 -0400, Vince Bonly wrote:
>> I have an AOO-Calc spreadsheet that has several "name box"
>> definitions, which I must revise or redefine the defined range. I
>> have forgotten how to define and / or edit the contents of the name
>> box definitions. And, I could not find info about "name box" in the
>> Help (F1) file. What I mean as the "name box" is the entry line with
>> a down arrow that is located to the left of the input line. This is
>> the area that shows the cell identification when a cell is
>> selected/highlighted. In other words, if I were to select the C60
>> cell in my spreadsheet, then C60 shows up in the name box area. If I
>> position the mouse cursor in this area, "Name Box" appears on screen.
>
> Yes, that drop-down menu box is called the Name Box, but the names
> themselves are called just "names".
>
> To define a name for a cell range:
> o Select the range.
> o Go to Insert | Names > | Define... .
> o Enter a name.
> o OK.
> To delete a name:
> o Go to Insert | Names > | Define... .
> o Select the name.
> o Delete.
> o Yes.
> o OK.
>
> To modify the definition of a name:
> o Go to Insert | Names > | Define... .
> o Select the existing name.
> o Drag across the new range.
> o Modify.
> o OK.
>
Would liked to have had a "More" or "Continue" button here instead of
clicking OK, etc.
> You could always modify any definition by deleting the existing one
> and creating a new one in the same name, of course.
>
> I trust this helps.
>
> Brian Barker
>
Brian:
Just to let you know that your suggestions / instructions workedout
splendidily here, and to say TNX again. Certainly was helpful. I do
wish, however, that there was a "More" or "Continue" button available,
rather than needing to go back to step one. I had to change the Named
Ranges for 13 columns that were shifted in the spreadsheet.
Regards,
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Need to Edit the name Box definitions
Posted by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID>.
TNX a bunch Brian. I will give that a try as I am about to update my
BVL Bowling Tournament spreadsheet for this year's competition.
On 3/19/2019 10:00 PM, Brian Barker wrote:
> At 20:48 19/03/2019 -0400, Vince Bonly wrote:
>> I have an AOO-Calc spreadsheet that has several "name box"
>> definitions, which I must revise or redefine the defined range. I
>> have forgotten how to define and / or edit the contents of the name
>> box definitions. And, I could not find info about "name box" in the
>> Help (F1) file. What I mean as the "name box" is the entry line with
>> a down arrow that is located to the left of the input line. This is
>> the area that shows the cell identification when a cell is
>> selected/highlighted. In other words, if I were to select the C60
>> cell in my spreadsheet, then C60 shows up in the name box area. If I
>> position the mouse cursor in this area, "Name Box" appears on screen.
>
> Yes, that drop-down menu box is called the Name Box, but the names
> themselves are called just "names".
>
> To define a name for a cell range:
> o Select the range.
> o Go to Insert | Names > | Define... .
> o Enter a name.
> o OK.
>
> To delete a name:
> o Go to Insert | Names > | Define... .
> o Select the name.
> o Delete.
> o Yes.
> o OK.
>
> To modify the definition of a name:
> o Go to Insert | Names > | Define... .
> o Select the existing name.
> o Drag across the new range.
> o Modify.
> o OK.
>
> You could always modify any definition by deleting the existing one
> and creating a new one in the same name, of course.
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org