Multiselection in a dropdown cell style

[Merlino]

How to implementation multiselection in a dropdown menu?

[psmolenski]

There is no way to implement multiselect using build in editors. You would have to write your own cell editor (possibly by extending an existing one). See Understanding cell editors for a detailed instruction on how to write your own cell editor.

[AMBudnik]

We are closing issues related to feature requests to create a full document based on that ideas from all our sources. It is avaiable is our wiki section.

[cumtwwei]

@AMBudnik
How to do it now? Please.
Just like i want to select the 'blue' and 'gray'.
Thanks a lot.

[AMBudnik]

Hi @cumtwwei the feature is not yet available.

[Even-Lau]

6 years passed. Why not solved yet? Would you please just add this feature?@AMBudnik
Have you solved it yet? @Merlino

[AMBudnik]

It was never the no 1 priority. We are aware that many users are waiting for this feature to be added, however, I cannot guarantee that it will be added this year.

[rashan]

Probably the following can be a solution:
https://github.com/mydea/handsontable-chosen-editor

Demo: http://mydea.github.io/handsontable-chosen-editor/

[sahul343]

Probably the following can be a solution:
https://github.com/mydea/handsontable-chosen-editor

Demo: http://mydea.github.io/handsontable-chosen-editor/

Thanks can I use it in react, are there any compatibility problems with react

[AMBudnik]

As there aren't many comments on closed issues, we decided to reopen the feature requests as Github Discussions.

Please feel free to share any feedback that will allow us to compose the full list of requirements for the proposed change.

Note to myself : update threads https://forum.handsontable.com/t/gh-2498-select-editor-with-multiple-selections-enable/5747/2, #2498, #9079, ZD

[andraz-podobnik]

My view on this: The Multi-select cell type (the version you developed) improvement suggestion:

• Currently: When Dropdown is opened, there’s only 1 column/property shown
• Future: It would be much better when it could show multiple columns/properties (maybe with integration of Handsontable cell type (https://handsontable.com/docs/handsontable-cell-type/) instead of Autocomplete?)

[abdelaziz321]

Hi Alexandra, @AMBudnik
Do you know if there is any future plan to support this one?

for anyone who wants to implement a very quick workaround. this approach worked for my case:

const settings: Handsontable.GridSettings = {
  // ...
  afterOnCellMouseDown(event, cell) => {
    if (cell.col == 1) {
      // open a dialog and map the user input to the cell using:
      this.hotTableRegisterer
        .getInstance('id')
        .setDataAtCell(cell.row, cell.col, valueFromDialog);
    }
  }
}

[AMBudnik]

Thank you for sharing your proposition here on github @abdelaziz321

The multiple-choice option for the dropdown cell type is high on our list of new functionalities. However, at the moment, we are working on Accessibility, and after that, we plan to add Themes. Those two projects will take us surely more than six months from now.

[abdelaziz321]

okay, thanks for your reply.

[xe4me]

Hi
2 years have passed since you said "The multiple-choice option for the dropdown cell type is high"
Any updates?

[AMBudnik]

Thank you for the feedback @xe4me We decided to focus on other priorities, so the multiple-choice option for the dropdown cell type is still not available. This year, we’re working on a major new feature, but it’s not the multiple-choice dropdown yet. Once we introduce this feature, we’ll make sure to announce it.

[gbuldrini]

Hey guys, is there any perspective on when this feature will be implemented ?

[adrianszymanski89]

Hi @gbuldrini

It's still in our backlog. We will update you when we have any news about the project.