Please post the full source code so that we can reproduce the problem on our side.
Yegor On Tue, Jan 17, 2012 at 7:22 PM, jamshid <[email protected]> wrote: > Hello, > I'm having problem with creating dropdown cells with many array items (this > is country list), It is actually working with approximately 100-150 > countries but not with all countries. When there are more countries, the > comma deliminated countries string will be in a cell. I'm using the latest > version of POI 3.8 beta 5 and still having problem. Here is the code which > is the same with given here: > http://poi.apache.org/spreadsheet/quick-guide.html#Validation Data > Validations > > Workbook workbook = new HSSFWorkbook(); > Sheet sheet = workbook.createSheet("Data Validation"); > CellRangeAddressList addressList = new CellRangeAddressList(0, 0, 0, 0); > DVConstraint dvConstraint = > DVConstraint.createExplicitListConstraint(countries); > DataValidation dataValidation = new HSSFDataValidation (addressList, > dvConstraint); > dataValidation.setSuppressDropDownArrow(false); > sheet.addValidationData(dataValidation); > > How can I solve this problem ? > Thanks in advance!!! > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Problem-creating-an-excel-cell-with-Drop-Down-Lists-tp5151878p5151878.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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
