I ran into an issue when loading my validations with many items. This may help: http://apache-poi.1045710.n5.nabble .com/Large-list-in-data-validation-produces-error-when-sheet-opens-tp3356946p3358273.html
-Lou jamshid <[email protected]> wrote on 01/17/2012 10:22:47 AM: > jamshid <[email protected]> > 01/17/2012 10:24 AM > > Please respond to > "POI Users List" <[email protected]> > > To > > [email protected] > > cc > > Subject > > Problem creating an excel cell with Drop Down Lists > > 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] >
