Hi Mark, User will select the value from list only. It's just that user should be able to type in the cell and the list should be narrowed down as per user's input (like usual comboboxes of web UI)
Right now user has to select the value by scrolling through whole list. Regards, Pratik Thaker -----Original Message----- From: Mark Beardsley [mailto:[email protected]] Sent: Saturday, April 25, 2015 4:18 PM To: [email protected] Subject: RE: Typable dropdown in excel file (XLSX) Can I make sure that I am clear what you want? Are you asking whether it is possible to create a drop down list that will change dynamically as the user enters something into a cell? If so, then I do not believe that this is possible; according to Microsoft, a data validation can only be used for the following - / * Make a list of the entries that restricts the values allowed in a cell. * Create a prompt message explaining the kind of data allowed in a cell. * Create messages that appear when incorrect data has been entered. * Check for incorrect entries by using the Auditing toolbar. * Set a range of numeric values that can be entered in a cell. * Determine if an entry is valid based on calculation in another cell. / (https://support.microsoft.com/en-us/kb/211485) If you do know of a way this can be accomplished using Excel directly, can I ask you to post the instructions here please? That way, someone can have a go at re-creating these steps with POI and help you that way. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Typable-dropdown-in-excel-file-XLSX-tp5718511p5718583.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] ________________________________ The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
