View original (French)

Dropdown list insertion with Open Office

Solved
tanchal29 Posted messages 90 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello everyone,
I have read the different posts about drop-down lists....but I can't manage it.
Could you please explain the process to me again using Open Office?
Thank you very much.
Chantal

Configuration: Mac OS X / Safari 533.19.4

6 answers

Answer 1 / 6
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello everyone

validating a list in Open Office:
write the list
select the cell field receiving the validation
toolbar /Data /Validity
in the window:
at the top choose: "cell range"
click in the bottom window and select the reference field that will then be entered in the window

You can also choose in this window the LIST option and enter the values in the bottom window.
Best regards

--
Let's ask ourselves if we are not the only ones to understand what we are explaining?
1
Answer 2 / 6
tanchal29 Posted messages 90 Status Member 19
 
Good evening Vaucluse and thank you for your help,
It's still not clear enough....
Column A contains the first names: 5 first names
Column B the age
Column C the contribution
I want to create a dropdown list for the first names on another sheet.
How should I do this.... should I enter the list of first names in the bottom window???
But if the list is large, it can be tedious???
Thank you
Chantal
0
Answer 3 / 6
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
To switch sheets:

create your list of five first names in column A
select it
Tools / Data / Define range
give it a name in the top window, for example NAME

on your second sheet
select the range to be processed
Tools / Data / Validity / Cell range
at the bottom enter the name of your field, (here NAME) without any other sign (no equal sign for example)

Regards

--
Let's ask ourselves if we are not alone in understanding what we are explaining?
0
Answer 4 / 6
tanchal29 Posted messages 90 Status Member 19
 
Hello,
I can now create a list on another sheet following your advice.
However, while I only select column A with my first names (to define the range), I am surprised to see the title and other data from other columns in the dropdown menu!
Is this normal?
Thank you very much for your help.
Chantal
0
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello
to clarify things, could you upload a model of your problem to:
http://www.cijoint.fr
and come back here to provide the link given by the site.
I'll take a look at it by the end of the morning if no one has resolved it by then
best regards
0
Answer 5 / 6
tanchal29 Posted messages 90 Status Member 19
 
Hello Vaucluse,
I am attaching my essay....
In fact, I want to create dashboards, so I am doing some trials.
Thank you for your help.
Chantal

http://www.cijoint.fr/cjlink.php?file=cj201103/cijx1YccNG.ods
0
Answer 6 / 6
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello Tanchal

Here is your arranged file below.
http://www.cijoint.fr/cjlink.php?file=cj201103/cijOnjzEHn.ods

I don't know much about Open, but testing a bit, I've come to the conclusion that you shouldn't give the list the name of a cell in the range, otherwise the entire range is taken.

But these are just assumptions...!

In any case, by naming the field A2:A5 MENU as in the template, it works better!
You also need to go to the Options tab in the validation window to uncheck
"the range contains labels"

this is to avoid the automatic display of the column title in A1 in the dropdown menu.

Keep me updated, I'm discovering this along the way!

Best regards

--
Let's ask ourselves if we are not the only ones who understand what we are explaining?
0