Apache OpenOffice (AOO) Bugzilla – Issue 102570
Extends the validation of values
Last modified: 2013-01-29 21:43:32 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
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?
Yes I Want to selct the Text for a table. When i edit the table i can select a vlaue from a list! Like 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
I do not understand. What do you need, what is not possible with the list box?
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
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.
Pick a value from the validation list and calculate with MATCH(validatedCell;SourceList;0). You could also associate arbitrary values in a 2-column list and calculate with: VLOOKUP(validatedCell;SourceList;2;0)