Disable certain options in dropdown cell

Tags: #<Tag:0x00007f8b2a16a528>
#1

Is there a way to disable certain options inside dropdown cell?
E.g.
Item 1 - disabled
Item 2
Item 3 - disabled
Item 4
Item 5

or if multi level dropdown can be created that would also work, like:
Item 1 - user should not be able to select this
Item 1.1
Item 1.2
Item 2 - user should not be able to select this
Item 2.1
Item 2.2

#2

Welcome @RajDev

there is currently no way to show an option but disable it. You can, however, filter it out on some certain conditions and change the list via updateSettings method.

#3

Thanks for the reply @aleksandra_budnik
If HTML select control is used for this column by setting this column as HTML type, how will the get/set methods work for it?

#4

This is an example with an HTML select inside a Handsontable cell with a HTML renderer turned on https://jsfiddle.net/handsoncode/ep6rahvn/ but get/set methods won’t work here https://jsfiddle.net/handsoncode/2nLv5m1s/

#5

Thanks @aleksandra_budnik
I’m trying to achieve the same with HoT in HoT. Hope it works as per requirement.

#6

Hey @RajDev

How’s the progress?

#7