EasyXLS
http://forum.easyxls.com/

Dropdown list
http://forum.easyxls.com/viewtopic.php?f=5&t=13
Page 1 of 1

Author:  ciprian [ Thu Mar 09, 2006 1:46 pm ]
Post subject:  Dropdown list

How can I construct a cell with a dropdown list with multiple values?

Author:  daniela [ Thu Mar 09, 2006 3:15 pm ]
Post subject:  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", "");

Author:  marsh [ Thu Apr 17, 2008 10:24 am ]
Post subject: 

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?

Author:  daniela [ Fri Apr 18, 2008 3:11 am ]
Post subject: 

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.

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/