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]
