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
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
#VA
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 l
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?
H
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-W
