Thanks for this, I cant find the original reply by Andreas, so this is Data Validation tool.
Jack ________________________________ From: Jean-Louis Oneto <jl.on...@free.fr> 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" <ville...@t-online.de> To: <users@global.libreoffice.org> Sent: Saturday, August 20, 2011 7:30 PM Subject: [libreoffice-users] Re: List Box Form Control changing Source Cell Range > menu:Data>Validation... > Accept: <Cell Range> > 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