Reply to topic  [ 4 posts ] 
Dropdown list 
Author Message

Joined: Thu Mar 09, 2006 1:39 pm
Posts: 1
Reply with quote
Post Dropdown list
How can I construct a cell with a dropdown list with multiple values?


Thu Mar 09, 2006 1:46 pm
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 157
Location: Brasov, Romania
Reply with quote
Post Data validation
By adding a data validator for a specified range and setting the list option for the validation type.

xlsFirstTab.easy_addDataValidator("A1:A10", DataValidator.VALIDATE_LIST, DataValidator.OPERATOR_EQUAL_TO, "=Your Range Formula or Name", "");


Thu Mar 09, 2006 3:15 pm
Profile WWW

Joined: Thu Apr 17, 2008 10:21 am
Posts: 1
Reply with quote
Post 
Hi there

I'm currently evaluating your .net version and can't figure out how to add a list of items to a dropdown for a specified column either.

I need to allow users to only be able to selct certain values .
How exactly do i need to specify the formula values for the validator?


Thu Apr 17, 2008 10:24 am
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 157
Location: Brasov, Romania
Reply with quote
Post 
For samples about how to set the formulas for data validation see our manual:
http://www.easyxls.com/manual/index.html
chapter EasyXLS Basics/Data Validation

You will find a sample about how to set the list of items for the dropdown.


Fri Apr 18, 2008 3:11 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 4 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.