Sorry to say this but as far as I am aware, there is no way to recover the values the user may have specified for the list validation. If you are lucky and the list validation has been constructed from a range of cells that ypou know about in advance of parsing the sheet then you would be able to recover the values from these cells.
If you felt like working on a patch for the API that adds this finctionality, then I am sure there will be many appreciative users. The easiest place to start would be with XSSF in my opionion as it is built over another layer called xmlbeans. Those classes are created by parsing the XSD schema for the xlsx file format and so there will almost certainly be methods somewhere that allow you to both get and set the list validations contents. If you need any help getting started, I am confident that someone od the dev list will help with advice. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Identifying-Combo-boxes-in-excel-sheets-tp3268561p3269309.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]
