2011/8/15 Andreas Säger <[email protected]>: > Am 15.08.2011 11:37, Jean-Louis Oneto wrote: >> >> Hello, >> I tried to define a combo box in Scalc which take its source cell range >> from a table. When I enter the cell reference directly, it works as >> expected. I defined a name for the table, but when I try to used it >> instead of the direct cell reference, I just get a blank combo box. I >> tried several syntax like 'name', ='name' but that doen't make any >> difference. I tried that both under version 3.3.3 (on Windows XP Pro 32 >> bit) and version 3.4.2 (on Windows 7 64 bit) as well as OpenOffice v3.3.0: >> That doesn't make any difference either. >> Is there a way to make that works? >> (In fact the original file was made with MS Excel XP) >> Thanks in advance, >> Jean-Louis >> > > Don't use form controls with spreadsheets. They are made for database input > in the first place.
If something should not be used, it should not exist. Why is it there if it's not supposed to be used? > menu:Data>Validation... Mine is grayed out… > Accept: <cell range> > ... does the trick accepting any formula expression, even calculated > references to dynamic ranges. > When you turn off the error message, you get the same behaviour as a combo, > which is just a text box with auto-complete suggestions. > Unlike form controls, this spreadsheet variant of a combo box can be copied > across ranges. > Hope this helps, > Andreas Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: [email protected] 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
