Bug 10214 - [RFE] No way to create dropdowns in cells with API
Summary: [RFE] No way to create dropdowns in cells with API
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-06-25 14:27 UTC by Craig Esterhuizen
Modified: 2008-05-28 08:45 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Craig Esterhuizen 2002-06-25 14:27:12 UTC
We need to be able to format a cell as a combo (dropdown) having supplied a 
list of valid values e.g. format cell 0,1 as a dropdown with these possible 
values (A1, A2, S3).  This can be done in Excel using Data | Validation | 
Settings | Allow = List, Source = A1,A2,S3. We need to be able to do this using 
the API.
We are using jakarta-poi-1.5.0-dev-20020416-bin.zip.  I have looked in the 1.7 
version but there is no method on HSSFCell for this.

Comment 1 Avik Sengupta 2002-06-26 04:26:19 UTC
Enhancement. Not on anyone's radar at the moment. 
Comment 2 Josh Micich 2008-05-28 08:45:59 UTC
Data validation was added in bug 27511 and bug 44007.  Some fixes (like bug 44201, bug 44710) have been applied since then.  POI seems to support the basic use cases OK.