This project has moved. For the latest updates, please go here.

Data Validations

Nov 8, 2014 at 7:20 PM
Is it possible to add data validations that come from a data source? I want to have the dropdown list come from my database lookup tables, as opposed to a range of existing cells.

I am creating a template, so the data validation would have to apply to the entire column, not just a cell.

Nice library!

Garth
Coordinator
Nov 8, 2014 at 8:12 PM
How would you do it in Excel?
Nov 10, 2014 at 11:42 AM
In data validations you create a list, but instead of specifying a range, its a comma separated list of values.

So "one,two,three" becomes a dropdown of these three values.
Coordinator
Nov 10, 2014 at 3:48 PM
cell.DataValidation.List("\"one,two,three\"");