Issue 102570 - Extends the validation of values
Summary: Extends the validation of values
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-06-06 17:29 UTC by erasergerman
Modified: 2013-01-29 21:43 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description erasergerman 2009-06-06 17:29:44 UTC
I want to create a rule of validation. I want to schow in the dropdownlist
values from B1:B10 und save the values A1:A10 like

Nr   Name
1    Test
2    Hello
3    World
4    ...

So i want to save the index of the values
Comment 1 Regina Henschel 2009-06-06 18:05:07 UTC
Use the form control "List Box" and set "Content of linked cell" to "Position of
the selected entry". You can hide the linked cell with the list box, if you will
only show the text entries.

Do you still wish a new feature?

Comment 2 erasergerman 2009-06-06 18:22:12 UTC
Yes I Want to selct the Text for a table. When i edit the table i can select a
vlaue from a list!

     A    B             C    D   E    F
1  text   <List Box>   text
2  text   <List Box>   text
3  text   <List Box>   text
4  text   <List Box>   text
n  text   <List Box>   text
Comment 3 Regina Henschel 2009-06-06 18:41:22 UTC
I do not understand. What do you need, what is not possible with the list box?
Comment 4 erasergerman 2009-06-07 19:17:17 UTC
A list bxo is one control so i must write a scriptfor use my idea

i want to use a wizzard to added data to the sheet! Like a databasewith mask for
the data
Comment 5 Regina Henschel 2009-06-07 20:09:14 UTC
Ok, cells with validity can be easier copied than form controls and need not be
aligned to cells. But I'm still not sure whether I could make it clear to you,
how to work with list boxes. List boxes do exact what you want: Select a value
from a list, which is given by a cell range, and return the index of the entry
in the list for further calculation.

Do not expect, that such a feature will be implemented soon. Therefore another
tip. You can calculate the index from the validation list by using the MATCH
function. You can hide this calculated value, if you put the calculation next to
the cell with the validity and then merge the cells.

Comment 6 villeroy 2009-07-16 23:48:32 UTC
Pick a value from the validation list and calculate with
You could also associate arbitrary values in a 2-column list and calculate with: