Re: [libreoffice-users] Linked Cell says True instead of Showing the value
Do you think that this could be a cell format problem? nvsoar On Aug 28, 2011 5:34 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/8/28 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Even just copypasting the equation into a reply to this thread might help ;) Regards from Tom :) Might help but not necessarily, I think. Depends on where the problem is. It's not always where it seems to be… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Sun, 28 August, 2011 11:52:49 Subject: Re: [libreoffice-users] Linked Cell says True instead of Showing the value 2011/8/28 Jack Cambel jcna2000-dauntl...@yahoo.com: What should I do when a linked value says True instead of the value it is supposed to reference or compute? I have a vlookup function that works partialy, the cell it is supposed to reference says true instead of the value it supposed to say. The cell it is supposed to reference is linked to a number field form.It works partially because some other values are derived from this and they turn out fine, still I have True where it should have a value. Thanks, Jack Can you upload an example file somewhere and give us the link here? That would make it a lot easier to answer your question. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Linked Cell says True instead of Showing the value
What should I do when a linked value says True instead of the value it is supposed to reference or compute? I have a vlookup function that works partialy, the cell it is supposed to reference says true instead of the value it supposed to say. The cell it is supposed to reference is linked to a number field form.It works partially because some other values are derived from this and they turn out fine, still I have True where it should have a value. Thanks, Jack -- For unsubscribe instructions e-mail to: users+h...@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] Linked Cell says True instead of Showing the value
2011/8/28 Jack Cambel jcna2000-dauntl...@yahoo.com: What should I do when a linked value says True instead of the value it is supposed to reference or compute? I have a vlookup function that works partialy, the cell it is supposed to reference says true instead of the value it supposed to say. The cell it is supposed to reference is linked to a number field form.It works partially because some other values are derived from this and they turn out fine, still I have True where it should have a value. Thanks, Jack Can you upload an example file somewhere and give us the link here? That would make it a lot easier to answer your question. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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] Linked Cell says True instead of Showing the value
Hi :) Even just copypasting the equation into a reply to this thread might help ;) Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Sun, 28 August, 2011 11:52:49 Subject: Re: [libreoffice-users] Linked Cell says True instead of Showing the value 2011/8/28 Jack Cambel jcna2000-dauntl...@yahoo.com: What should I do when a linked value says True instead of the value it is supposed to reference or compute? I have a vlookup function that works partialy, the cell it is supposed to reference says true instead of the value it supposed to say. The cell it is supposed to reference is linked to a number field form.It works partially because some other values are derived from this and they turn out fine, still I have True where it should have a value. Thanks, Jack Can you upload an example file somewhere and give us the link here? That would make it a lot easier to answer your question. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Linked Cell says True instead of Showing the value
2011/8/28 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Even just copypasting the equation into a reply to this thread might help ;) Regards from Tom :) Might help but not necessarily, I think. Depends on where the problem is. It's not always where it seems to be… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Sun, 28 August, 2011 11:52:49 Subject: Re: [libreoffice-users] Linked Cell says True instead of Showing the value 2011/8/28 Jack Cambel jcna2000-dauntl...@yahoo.com: What should I do when a linked value says True instead of the value it is supposed to reference or compute? I have a vlookup function that works partialy, the cell it is supposed to reference says true instead of the value it supposed to say. The cell it is supposed to reference is linked to a number field form.It works partially because some other values are derived from this and they turn out fine, still I have True where it should have a value. Thanks, Jack Can you upload an example file somewhere and give us the link here? That would make it a lot easier to answer your question. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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