Re: [libreoffice-users] Referencing to a cell name on another sheet

[Johnny Rosenberg]

Thanks for your response, Brian, Michael and Pedro.

It seems like I misunderstood what was really happening, and I'm still not
sure.
I opened the Manage names dialogue and the fps name referred to sheet name
and cell, so it should just work. I deleted the name and added it again,
and did a simple test with just =fps on the other sheet and it worked. I'm
not sure why it didn't work before. I probably did something that I wasn't
aware about…

Anyway, your responses inspired me to make it work, I think, thanks again.
Problem solved!


Kind regards

Johnny Rosenberg



2017-04-02 17:58 GMT+02:00 Brian Barker :

> At 17:15 02/04/2017 +0200, Johnny Rosenberg wrote:
>
>> An example: Let's say I have two sheets: XSheet and YSheet. On XSheet I
>> named cell AA1 "fps". In cell XSheet.Z2 I have the following:
>> =fps*(V2-W2*3600-X2*60-Y2)
>> This works fine.
>>
>> However, the same thing doesn't work on YSheet. The result is #VALUE!
>> I've also tried things like =XSheet.fps*(V2-W2*3600-X2*60-Y2), but with
>> no success. Also, I can't name a cell "fps" on YSheet, since the name is
>> already taken.
>>
>
> Is the named rage "fps" defined as "$AA$1"? I think that may be your
> problem. What happens if you change the definition explicitly to
> "$XSheet.$AA$1" - in other words, to put its allegiance to XSheet in the
> definition of the named range instead of trying to put it in the reference?
>
> If you select the required range first and then use Insert | Names > |
> Define... to create the name, does the range offered not already include
> the sheet name?
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Referencing to a cell name on another sheet

[Brian Barker]

At 17:15 02/04/2017 +0200, Johnny Rosenberg wrote:
An example: Let's say I have two sheets: XSheet and YSheet. On 
XSheet I named cell AA1 "fps". In cell XSheet.Z2 I have the following:

=fps*(V2-W2*3600-X2*60-Y2)
This works fine.

However, the same thing doesn't work on YSheet. The result is 
#VALUE! I've also tried things like 
=XSheet.fps*(V2-W2*3600-X2*60-Y2), but with no success. Also, I 
can't name a cell "fps" on YSheet, since the name is already taken.


Is the named rage "fps" defined as "$AA$1"? I think that may be your 
problem. What happens if you change the definition explicitly to 
"$XSheet.$AA$1" - in other words, to put its allegiance to XSheet in 
the definition of the named range instead of trying to put it in the reference?


If you select the required range first and then use Insert | Names > 
| Define... to create the name, does the range offered not already 
include the sheet name?


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Convert old numbering style into current one

[Tom Davies]

Hi :)
Did anyone have an answer about this?
Regards from
Tom :)

On 5 Mar 2017 18:48, "Regina Henschel"  wrote:

> Hi all,
>
> there exist an old numbering style with "Minimum space between numbering
> and text" and the current numbering style with "Numbering followed by".
>
> Sometimes I need to load a document, which has an old numbering style and
> resave it in "ODF1.2 extended" for to use new features. But saving in new
> format does not convert the old numbering style to the current one.
>
> Is there an easy way to convert old numbering style to current numbering
> style? I know how to do it in file source directly, but I'm looking for an
> easy way, directly in the UI. Loading styles from a new dummy document is
> no option, because that would not only overwrite this one style but a lot
> of others too.
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Referencing to a cell name on another sheet

[Pedro]

Johnny Rosenberg wrote
> So what is the proper way to handle this? How can I reference a cell name
> on another sheet?

Assuming you are referring to another Sheet in the same file, it does work
as you described (using version 5.3.2.2 x64 under Windows 10 x64)
Which OS, LO version are you using?

Here is an example that does work. Named range fps is in cell AA1
Named_range.ods
  



--
View this message in context: 
http://nabble.documentfoundation.org/Referencing-to-a-cell-name-on-another-sheet-tp4211608p4211618.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Referencing to a cell name on another sheet

[Johnny Rosenberg]

Hi!

An example:
Let's say I have two sheets: XSheet and YSheet.
On XSheet I named cell AA1 ”fps”.
In cell XSheet.Z2 I have the following:
=fps*(V2-W2*3600-X2*60-Y2)

This works fine.
However, the same thing doesn't work on YSheet.
The result is #VALUE!
I've also tried things like =XSheet.fps*(V2-W2*3600-X2*60-Y2), but with no
success.
Also, I can't name a cell ”fps” on YSheet, since the name is already taken.

So what is the proper way to handle this? How can I reference a cell name
on another sheet?




Kind regards

Johnny Rosenberg

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted