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

Le 15/08/2011 16:55, Andreas Säger a écrit :
> 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.
> menu:Data>Validation...
> 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
In fact I had found a very similar thread (with a very similar 
answer...) in the OO forum:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=38322&p=175957&hilit=combo+box#p175957
but the problem is that in either case I am unable to understand the 
solution.: I was able to define a Data:Validation..Accept:CellRange, but 
only if I'm not in Form creation mode, otherwise all the entries of the 
Data mennue are greyed out. And if define a CellRange with a name, then 
I'm unable to use it in the combo box (or a list box)

I don't understand either why there are controls in Scalc which are 
supposed to be left unused. And with all the hectic thread about Base 
and databases, I even feel that if I should avoid something, that would 
be... databases! Besides that, I just need to choose a set of parameters 
from list of less than ten entries, and I would feel like overkill to 
build a database for that!

-- Jean-Louis Oneto e-mail: jl.oneto@free.fr

--
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