OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Data Validity -- how to set default cell value

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
mamba
Power User
Power User


Joined: 13 May 2005
Posts: 75
Location: Australia, USA and Africa

PostPosted: Sun Nov 05, 2006 6:08 pm    Post subject: Data Validity -- how to set default cell value Reply with quote

I have a cell with 3 values possible (yes, no, maybe), which I can set through Data --> Validity --> List.

However, the cell is blank unless the user clicks on the drop down list button. I need one of the three values ("no") to appear in that cell by default. How do I do this please?

Ta
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Sun Nov 05, 2006 9:15 pm    Post subject: Reply with quote

Why not just enter "no" in the first cell and drag down to the last cell? (I've missed the point, haven't I?)
_________________
search forum by month
Back to top
View user's profile Send private message
mamba
Power User
Power User


Joined: 13 May 2005
Posts: 75
Location: Australia, USA and Africa

PostPosted: Sun Nov 05, 2006 11:05 pm    Post subject: Reply with quote

That's a quick and nasty fix. It's a pity the Validity panel in Calc doesn't allow one to set a default value from the list that it allows you to create ...

Also, when you tab into the cell, you should be able to use the UP/DOWN arrow keys to select one of the values.


Wishlist for next version? Please?
Back to top
View user's profile Send private message
jgn
OOo Enthusiast
OOo Enthusiast


Joined: 17 Jul 2006
Posts: 130

PostPosted: Sun Nov 05, 2006 11:06 pm    Post subject: Reply with quote

my suggestion to you is, use the template instead of spreadsheet i think this will resolve the problem
means open the spreadsheet and save as openoffice document template *.odt
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Nov 06, 2006 3:33 am    Post subject: Reply with quote

The validation-feature is nothing more than a input-help for simple spreadsheet-lists. There is nothing which prevents you from clearing, deleting or pasting over validated sheet-cells. A spreadsheet-cell is deliberately designed to take any kind of value.
This is not a database-engine. A database provides all this and so much more, because it is designed for keeping unique items of explicitly declared types of data within explicitly defined ranges, explicitly defined default-values or time-stamps and explicitly defined privileges, related to other tables with unique items of explicitly ....
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group