Re: [libreoffice-users] Re: Problem with combo box

2011/8/15 Andreas Säger <villeroy@t-online.de>:
> 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: users+help@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