Then I am sorry to say I do not believe that is possible in Excel; I am saying that I suspect it is a limitation of the Excel GUI not of POI. What I do know you can do is create lists that depend upon one another - for example the selection you make in a list in cell A1 for example will determine the values you can see in a list in cell A2 but there is not a way, at least as far as I am aware, to create the sort of lists you require.
The best advice I can offer is to find an Excel forum or list similar to this one and ask the question there. If someone can offer a solution, then it might be possible to replicate it using POI. If there is a solution, I suspect it will involve macros and I am not certain how POI's support for macro programming has developed recently. If you do have to use macros to accomplish this task - and that is 'if' as an Excel guru may know a straightforward way to achieve this task - then it might be best to create the macro in a workbook and then use POI to open and populate that workbook. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Typable-dropdown-in-excel-file-XLSX-tp5718511p5718585.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]
