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: [email protected]
--
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
