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

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+unsubscribe@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