Well, if you need lots of options in the drop-down list, why not write the data into contiguous cells on the sheet, make that into a named area and use it as the basis for the drop-down? I am sure there is a limit to the size of the drop-down using this technique also and you may need to experiment to discover what that is. Earlier, I posted an example that uses a separate sheet to contain the data for the drop down lists; this sheet can be hidden so that the final user of the workbook is unaware of it. If you do this, you will need formula list constraints and not straightforward list constraints, but Excels' formulae and functions are nothing to be scared of.
Also, I noticed that, in your example, your drop-down list appears to be very large. Is this what you want? Typically, a drop-down list is contained in a single cell and only appear fully when the user clicks on the downward facing arrow alongside that cell. When using drop-downs myself, I have typically created CellRangeAddressList instances like this; new CellRangeAddressList(0, 0, 0, 0) - to make the drop down appear in cell A1 in this case. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/ERROR-String-literals-in-formulas-can-t-be-bigger-than-255-characters-ASCII-tp5507262p5507344.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]
