poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Louis.Mast...@log-net.com
Subject Re: Problem creating an excel cell with Drop Down Lists
Date Tue, 17 Jan 2012 16:23:59 GMT
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 <jamshid.asatillayev@gmail.com> wrote on 01/17/2012 10:22:47 AM:

> jamshid <jamshid.asatillayev@gmail.com> 
> 01/17/2012 10:24 AM
> 
> Please respond to
> "POI Users List" <user@poi.apache.org>
> 
> To
> 
> user@poi.apache.org
> 
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message