[libreoffice-users] Spreadsheet Design Services?
Hi, Sorry if this not related to User. I was wondering if there are any spreadsheet design services that uses libreoffice anyone can point me towards. I'm curious about if such a business exists and how much such would charge. Thanks in advance, 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
[libreoffice-users] Re: Linked Cell says True instead of Showing the value
So sorry for the late reply, it got lost in the flood of mail. I have to figure out to better organize my mail. I figured it out, I don't know why or how but Cell Format was set in Boolean Value. Jack Mon, 29 Aug 2011 03:46:00 -0700 Am 29.08.2011 09:13, nvrk wrote: Do you think that this could be a cell format problem? nvsoar Could be. Nobody can tell without any data nor formulas from the original poster. Unlike Excel, the boolean data type is just a subtype of the decimal type. The number format "BOOLEAN" displays any non-zero number as TRUE and all the rest as FALSE. In Excel there is a separate boolean data type, so TRUE and FALSE are never equal to any number. -- 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] Re: List Box Form Control changing Source Cell Range
Thanks for this, I cant find the original reply by Andreas, so this is Data Validation tool. Jack From: Jean-Louis Oneto To: users@global.libreoffice.org Sent: Monday, 22 August 2011 7:59 AM Subject: Re: [libreoffice-users] Re: List Box Form Control changing Source Cell Range Hello, I didn't notice the link to example file at first glance, but the alternative of using the Data Validation tool is really very powerful! I would never found it by myself without your example! It is really an nice solution and it surely deserve a better publicity in the doc. Thanks a lot to all of you, Jean-Louis - Original Message - From: "Andreas Säger" To: Sent: Saturday, August 20, 2011 7:30 PM Subject: [libreoffice-users] Re: List Box Form Control changing Source Cell Range > menu:Data>Validation... > Accept: > accepts any formula expression including calculated references: > http://user.services.openoffice.org/en/forum/download/file.php?id=333 > > -- > View this message in context: > http://nabble.documentfoundation.org/List-Box-Form-Control-changing-Source-Cell-Range-tp3270318p3271238.html > Sent from the Users mailing list archive at Nabble.com. > > -- 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
Re: [libreoffice-users] Recalculate Rand between targeting a particular Cell or Cell Range
Thanks Tom, I appreciate the help on both counts. :) Jack From: Tom Davies To: users@global.libreoffice.org Sent: Saturday, 20 August 2011 6:28 PM Subject: [libreoffice-users] Recalculate Rand between targeting a particular Cell or Cell Range Hi :) I think this needed to be posted as a new thread aswell. I might have made a mistake with the last one i did this to. Many apols to all if that was wrong. Good luck and regards from Tom :) From: Jack Cambel To: "users@global.libreoffice.org" Sent: Fri, 19 August, 2011 4:20:20 Subject: [libreoffice-users] Re: Recalculate Randbetween targeting a particular Cell or Cell Range Hello, I want to learn how to create a button to recalculate a cell with randbetween function. I know it is going to be a bit complicated, can anyone point out where I can I find resources online and where I can have a handy reference of the macros. Thanks in advance, Jack LibreOffice 3.3.2 OOO330m19 (Build:301) tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5 -- 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] Re: Recalculate Randbetween targeting a particular Cell or Cell Range
Hello, I want to learn how to create a button to recalculate a cell with randbetween function. I know it is going to be a bit complicated, can anyone point out where I can I find resources online and where I can have a handy reference of the macros. Thanks in advance, Jack LibreOffice 3.3.2 OOO330m19 (Build:301) tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5 -- 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] List Box Form Control changing Source Cell Range
Hello, I want to make a list box (in Forms Control) affect the choices of another list box. Is there a function that allows me change ranges in the cells referenced in a List Box's source cell range? -- 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