poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Louis.Mast...@log-net.com
Subject RE: XSSF Data Validation in POI 3.7
Date Wed, 22 Sep 2010 16:26:10 GMT

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);

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 <nick.burch@alfresco.com> 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 
> > 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 
> 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

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