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

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

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

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

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".

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

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?

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

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