Dropdown lists in OpenOffice.org Calc
Dropdown lists are a mainstay of many spreadsheets and forms. They help you control what people can enter, as well as giving them ideas for what types of things they might say.
You can make dropdown lists in a couple ways, at least, in OpenOffice.org. The simplest way is to use the tools accessed under Data > Validity. The lists are easy to make, plus you can easily use the values in formulas. In the following illustration, the value in B2, selected from a dropdown list, is referenceable in another cell.
Another way you can use the values in the dropdown list (among many) is to concatenate them. Click the following illustration to see it larger. The formula