Hi Ryan, unfortunatly I have experienced this situation some weeks ago, and the only solution i found was to use template sheets with dropdown list already defined in it.
Laurent -----Message d'origine----- De : Ryan Crumley [mailto:[EMAIL PROTECTED] Envoy� : vendredi 27 f�vrier 2004 21:47 � : [EMAIL PROTECTED] Objet : Add listbox to spreadsheet via POI I am creating a servlet based application that allows the user to export data to excel, edit it, and upload it back to the servlet for processing. Some columns in this spreadsheet contain values that are to be selected from a list of values. For instance column D might accept "circle", "triangle, or "square". It would be very convenient if I could generate listboxes in the cells of column D so the user can use the listbox to select from those 3 allowed values. It looks like excel supports listboxes through validators on the cell and the "forms" toolbar (using VB or ActiveX controls). Does anyone have experience using POI to create these type of controls? Thanks, ryan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
