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