Bug 10214 - [RFE] No way to create dropdowns in cells with API
Summary: [RFE] No way to create dropdowns in cells with API
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-06-25 14:27 UTC by Craig Esterhuizen
Modified: 2008-05-28 08:45 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

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.

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.