openoffice / libreoffice value constraints
 

In libreoffice (openoffice) can I constraint cell values to a set of user defined values? For example, a cell in the "Vehicle Type" column must be either "Truck", "Car", or "Motorcycle". (A pop-up selection box would be nice too.)

I think you would need a data base application for that, like Libreoffice Database or so

There is a way into calc to have a cell with a list of predefined items. To do so from the top menu select Datas -> Validate and make your choice from the list of options. An example, If you select "data range" you can select an range of cells that will be available from your list.

Thanks, you da man! Once I got to the Data -> Validity window, there was actually a "List" option which allowed me to provide a newline list of allowed values, so I used that. It provided the pop up menus and allowed me to choose whether or not to allow empty cells.