Not sure I understand what the problem really is here. I am assuming that you are populating the data validation using POI and that you know in advance what value you want to be displayed to the user when the sheet is opened. If so, then surely, all you need to do is set the cell to that value before you save the sheet away. Think of it not as a default value for the validation but a default value for the cell. All the validation is really doing is prescribing the range of values the user can enter and as long as you try to set the cell to one of the values from it's list, all should be well; you will need to set the value after adding the validation to the sheet of course.
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-set-default-value-in-DropDownList-cell-tp5710452p5710453.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
