Return-Path: X-Original-To: apmail-poi-user-archive@www.apache.org Delivered-To: apmail-poi-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 873799AEB for ; Tue, 17 Jan 2012 16:24:02 +0000 (UTC) Received: (qmail 86888 invoked by uid 500); 17 Jan 2012 16:24:02 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 86708 invoked by uid 500); 17 Jan 2012 16:24:01 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 86700 invoked by uid 99); 17 Jan 2012 16:24:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Jan 2012 16:24:01 +0000 X-ASF-Spam-Status: No, hits=3.5 required=5.0 tests=HTML_MESSAGE,NUMERIC_HTTP_ADDR,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.104.202.5] (HELO rbkmail01.log-net.com) (63.104.202.5) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Jan 2012 16:23:55 +0000 In-Reply-To: <1326813767014-5151878.post@n5.nabble.com> References: <1326813767014-5151878.post@n5.nabble.com> To: "POI Users List" Subject: Re: Problem creating an excel cell with Drop Down Lists MIME-Version: 1.0 X-Mailer: Lotus Notes Release 8.0.1 February 07, 2008 Message-ID: From: Louis.Masters@log-net.com Date: Tue, 17 Jan 2012 11:23:59 -0500 X-MIMETrack: Serialize by Router on RBKMAIL01/LOG-NET(Release 7.0.1|January 17, 2006) at 01/17/2012 11:24:23 AM, Serialize complete at 01/17/2012 11:24:23 AM Content-Type: multipart/alternative; boundary="=_alternative 005A0CF185257988_=" --=_alternative 005A0CF185257988_= Content-Type: text/plain; charset="US-ASCII" 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 wrote on 01/17/2012 10:22:47 AM: > jamshid > 01/17/2012 10:24 AM > > Please respond to > "POI Users List" > > 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 > --=_alternative 005A0CF185257988_=--