Sorry top say that this is a limitation imposed by Excel, not by POI; if you try to do something like this using Excel, it will also create separate entries for the comma separated items. Also, as far as I am aware, there is no way to escape the comma in the list.
To my mind, you have two options. Option one is to create the validation from the contents of cells. In that way, one of the cells could contain a string such as A, B and be included in the validation. The second option is to replace the comma with ascii character 130. This is not the comma but it does look very like it. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Problem-using-datavalidation-with-explict-list-constraint-tp5712093p5712102.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]
