CODEWITHSUNDEEP
excelapache-poilibreoffice
Rider
Rider

Reputation: 473

How to add multi-select dropdown in excel using poi

I have an list of Strings (A,B,C,D,E) and i have added this list to cell using range and data validity in libre office. but it only selects one value at a time. I want something like if i select first D and then C output should be like D,C multi-select. I have already studied all the questions on stack overflow but i haven't found anything. Thanks, in advance.

Upvotes: 3

Views: 4662

Answers (2)

user3370281
user3370281

Reputation: 111

POI doesn't support multi select drop down.

You can follow the below link. http://poi.apache.org/spreadsheet/quick-guide.html#Validation

Upvotes: 3

centic
centic

Reputation: 15882

As the provided link requires VBA scripting to do things, it is not possible to do this in POI currently as support for reading/adding VBA code is very limited. You could try to add it via the low-level API of POI, but would first find out where Excel stores the VBA code inside the .xlsx-file (it's actually a zip-file, so you can unzip it and take a look).

See the following for some pointers:

Upvotes: 3

Related Questions