Apache OpenOffice Community Forum

Hi!
Is it possible to show diffrent droplists in a specific cell depending on value in another cell?
If so! Someone who wants to help me with a solution?

You must use helper tables for the data range of each Data Validity cell. The values of the actual list will be choosen ased on the value of the condition Drop-down (A, B, C) by usage of the Vlookup() function.

In other words you will refresh dinamically the content of the cellrange of the Data validity cell - instead of the usage of static values.

Zizi64 already hinted that the mode Cell range in the first tab of the >Data > Validity dialog may be named slightly misleading. In fact you needn't enter a constant range reference there, but can also give a correct expression resulting in such a range reference or an array of data. Besides the VLOOKUP() other lookup functions (HLOOKUP, LOOKUP) and the INDEX() function used with only the row or only the column parameter are capable of delivering an array, OFFSET() and INDIRECT() can return a range reference.
An expression selecting one of some (three in your case) array constants is also a (crude) way to achieve what you want. This closes the gap to the List mode under Criteria.
See attached demo. See also viewtopic.php?f=9&t=85196.

Zizi64 and Lupp! Thanks to both of you!
You guys really solved my problem in a good way.