LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices

Reply
 
Search this Thread
Old 07-25-2011, 01:00 PM   #1
tinyTux
Member
 
Registered: Mar 2011
Location: Extended Memory
Distribution: Gentoo
Posts: 64

Rep: Reputation: 8
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.)
 
Old 07-25-2011, 02:06 PM   #2
Nabeel
Member
 
Registered: Nov 2009
Location: Pakistan
Distribution: Ubuntu
Posts: 291

Rep: Reputation: 17
I think you would need a data base application for that, like Libreoffice Database or so
 
Old 07-25-2011, 03:26 PM   #3
didicosse
LQ Newbie
 
Registered: Feb 2011
Location: Nantes
Distribution: Ubuntu Mandriva Debian
Posts: 4

Rep: Reputation: 1
Quote:
Originally Posted by tinyTux View Post
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.
 
1 members found this post helpful.
Old 07-26-2011, 11:31 AM   #4
tinyTux
Member
 
Registered: Mar 2011
Location: Extended Memory
Distribution: Gentoo
Posts: 64

Original Poster
Rep: Reputation: 8
Quote:
Originally Posted by didicosse View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] compatibility of LibreOffice with OpenOffice wiliamvw Linux - Software 9 12-29-2011 10:23 AM
[SOLVED] Ugly menus in openoffice/libreoffice vitorsgoncalves Linux - Software 4 04-21-2011 04:56 PM
LXer: LibreOffice VS Openoffice LXer Syndicated Linux News 1 02-10-2011 05:48 AM
LXer: Goodbye OpenOffice. LibreOffice, Here I Come! LXer Syndicated Linux News 0 09-30-2010 01:50 AM
LXer: LibreOffice Is The New OpenOffice.org LXer Syndicated Linux News 5 09-29-2010 05:25 PM


All times are GMT -5. The time now is 06:46 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration