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]
