Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 23954 invoked from network); 22 Sep 2010 16:26:56 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Sep 2010 16:26:56 -0000 Received: (qmail 4417 invoked by uid 500); 22 Sep 2010 16:26:56 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 4380 invoked by uid 500); 22 Sep 2010 16:26:55 -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 4042 invoked by uid 99); 22 Sep 2010 16:26:55 -0000 Received: from Unknown (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Sep 2010 16:26:55 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.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; Wed, 22 Sep 2010 16:26:33 +0000 In-Reply-To: To: "POI Users List" Subject: RE: XSSF Data Validation in POI 3.7 MIME-Version: 1.0 X-Mailer: Lotus Notes Release 7.0.1 January 17, 2006 Message-ID: From: Louis.Masters@log-net.com Date: Wed, 22 Sep 2010 12:26:10 -0400 X-MIMETrack: Serialize by Router on RBKMAIL01/LOG-NET(Release 7.0.1|January 17, 2006) at 09/22/2010 12:26:37 PM, Serialize complete at 09/22/2010 12:26:37 PM Content-Type: multipart/alternative; boundary="=_alternative 005A47AD852577A6_=" X-Virus-Checked: Checked by ClamAV on apache.org --=_alternative 005A47AD852577A6_= Content-Type: text/plain; charset="US-ASCII" Nick: I did not check it against HSSF - I don't think that is the issue. The issue is that the documentation on http://poi.apache.org/spreadsheet/quick-guide.html#Validation states: Drop Down Lists: This code will do the same but offer the user a drop down list to select a value from. HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("Data Validation"); CellRangeAddressList addressList = new CellRangeAddressList( 0, 0, 0, 0); DVConstraint dvConstraint = DVConstraint.createExplicitListConstraint( new String[]{"10", "20", "30"}); HSSFDataValidation dataValidation = new HSSFDataValidation (addressList, dvConstraint); datavalidation.setSuppressDropDownArrow(false); Notice the "false" in the suppress statement - in 3.7 b2, it needs to be "true" for the drop down to appear. Maybe a simple documentation issue? Nick Burch wrote on 09/22/2010 11:30:44 AM: > On Wed, 22 Sep 2010, Goris, Jason wrote: > > Yeah, it appears that the setSuppressDropDownArrow() method is backwards > > from what I would have expected (and what worked for HSSF). Thank you > > for your help! > > If there is something that is inconsistent between HSSF and XSSF, please > create a new bug in bugzilla, and upload either some code to generate the > two files that differ, or even better a failing unit test! > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org > For additional commands, e-mail: user-help@poi.apache.org > --=_alternative 005A47AD852577A6_=--