Ask Your Question

How can I create dynamic dropdown in Libreoffice Calc? [closed]

asked 2015-10-14 23:22:50 +0200

joannesalfa gravatar image

I'm trying to make 2 dropdowns as country and its states, I couldn't figure out how to make dynamic dropdown for list of states according to selected country in Libreoffice Calc. This is example:

image description


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-17 02:54:49.790396

1 Answer

Sort by » oldest newest most voted

answered 2015-10-16 02:03:23 +0200

Regina gravatar image

You can do that with Data > Validity. Use the criteria Cell Range and enable the option Show selection list. For your country you determine the range directly. For the State you need a nested formula. The outer part is the function INDEX. The range for this function is a range, with all states of one country in a column and those of another country in the next column. The second parameter of INDEX is the row. If you leave it empty the column is taken. The third parameter is the column and that is calculated. You search the country, which comes from your country drop-down list in the column headers of the country-state range using MATCH. For an example see the attached file ValidityDropDown.ods

edit flag offensive delete link more


Sorry for delay, I got your answer and it works, thanks!

joannesalfa gravatar imagejoannesalfa ( 2015-10-27 00:34:40 +0200 )edit

Question Tools

1 follower


Asked: 2015-10-14 19:37:58 +0200

Seen: 2,009 times

Last updated: Oct 16 '15