Bug 10214

Summary: [RFE] No way to create dropdowns in cells with API
Product: POI Reporter: Craig Esterhuizen <craig.esterhuizen>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: enhancement    
Priority: P3    
Version: 2.0-dev   
Target Milestone: ---   
Hardware: All   
OS: All   

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.

Regards
Craig
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.