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 <[email protected]> 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: [email protected]
> For additional commands, e-mail: [email protected]
>
