Data Validation is not currently supported. And using Forms and Dialogs will cause macros to be created, which are also not supported.
I can think of two possibilities 1. An earlier poster has stated that they have implemented the DV record types necessary for data validation. So I suppose a patch may be coming soon. You can read the post at http://www.mail-archive.com/[EMAIL PROTECTED]/msg07714.html. I don't think the patch has been contributed yet. 2. You can build a template with a dropdown list populated from a named range. (I.e., write a macro to populate the dropdown from a range). Now use POI to copy this template, populate the values in the named range - you can even change the number of elements. Let us know how/if it works. -----Original Message----- From: Ryan Crumley [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 3:47 PM To: [EMAIL PROTECTED] Subject: 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]
