LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Desktop (http://www.linuxquestions.org/questions/linux-desktop-74/)
-   -   openoffice / libreoffice value constraints (http://www.linuxquestions.org/questions/linux-desktop-74/openoffice-libreoffice-value-constraints-893680/)

tinyTux 07-25-2011 01:00 PM

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.)

Nabeel 07-25-2011 02:06 PM

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

didicosse 07-25-2011 03:26 PM

Quote:

Originally Posted by tinyTux (Post 4424780)
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.)

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.

tinyTux 07-26-2011 11:31 AM

Quote:

Originally Posted by didicosse (Post 4424879)
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.


All times are GMT -5. The time now is 10:01 PM.