Dropdown key value_

Hi @suman.dutta

This solution isn’t perfect. As @aleksandra_budnik mentioned it was created some time ago by our developer just to show that such solution is possible with the current state of Handsontable, but it has its flaws.

Because of that we won’t recommend to use it as a production code, but rather as a proof of concept and wait until we implement this feature natively.

Okay thanks for your response

Any update on the key/value for dropdown/autocomplete options?

Hi @itsjasur_handsontabl

Not yet, we will update this topic as soon as this feature is available.

Hi! I needed this feature, so I slightly tweaked the code above. It seems to work as expected — though it does feel a bit like a hack https://jsfiddle.net/n1xruwjc/11/

Hi @valery.yugai

Thank you for sharing your implementation. I hope that we will support this functionality natively in the nearest future.

Hi

We know you’ve been waiting for the key-value dropdown cell type, and we have some great news.
We’ve developed a proof of concept (POC). Would you be interested in testing it before we publish it?

Hi.

We just launched Handsontable v16.1.0, where you can set up your key-value dropdown/autocomplete cell.

Here is the corresponding pull request https://github.com/handsontable/handsontable/pull/11773 that also adds two new methods: valueGetter and valueSetter.

In this guide, you can test it out Autocomplete cell type - React Data Grid | Handsontable , and here is the full list of changes Changelog - React Data Grid | Handsontable - we also added LTS support, Pagination, and a Loading screen.

Hope you’ll like it.

1 Like