How to pass key value pair to handsontable dropdown?

[chan...@gmail.com]

Hi is there any way to pass keyvalue pair to handsontable dropdown.

have id,Name display the name in Ui and store the id in Database.

any sample app is great help.

[trebuchetty]

There's no way to do this with the predefined set of editors.

I've made a Select2 editor for handsontable that you may find useful: https://github.com/trebuchetty/Handsontable-select2-editor

Other than that, you can extend one of the existing editors to do whatever you need: 

https://github.com/handsontable/jquery-handsontable/wiki/Custom-cell-editor

https://github.com/handsontable/jquery-handsontable/wiki/Understanding-cell-editors

Hope that helps,

[chan...@gmail.com]

HI,
Could you have any sample how to use this selectEditor i am trying to use this but not able to if you have any sample html page it is really helps me alot

Thanks in advance.

[chan...@gmail.com]

HI,
I checked your sample2 editor it is displaying as text area and disabling all dropdowns.Let me know is there any specific configuration required.
Regards,
Chandra

[trebuchetty]

I've just added some fixes to the editor to bring it up to my production code.

As for it's use, I have something like this in my columns object for handsontable:

{

    data: 'ManufacturerPartNo',

    renderer: itemStatusAutocompleteRenderer,

    editor: 'select2',

    select2Options: this.select2ItemsListOptions('ManufacturerPartNo', this.model.get('CompanyName'))

},

The select2Options is just an options object that you would use to build any select2 dropdown. At the very least you'll need a data property and a query property. Go to Select2's documentation to figure out what you'll need for your specific use. Also, make sure you include the select2.js code in your build (obviously).

Hope that helps.

[Luke]

Hi Trebuchetty,

I'm using your excellent handsontable select2 editor, but when I select an option, the id value, not the text value is displayed in the cell. I have tried to write a custom renderer for this, but how do I make sure it displays the text, but still submits the id value. Earlier in this thread, you implied that the select2 editor would allow for that somehow.

Thanks,

Luke.

[trebuchetty]

The Select2 editor does allow for that. It's all in how you setup the select2 editor with the initialization options. Go to the select2 website to see all the available options. At the very least, the data object for the select2 dropdown should contain an "id" and "text" field so that what you see and what you actual select are correct.

[madhu....@gmail.com]

I am running into a similar issue. I am using select2-editor and it is displaying the id instead of the value. Also, clicking on the row is not aligning the select2 dropdown. Here is the jsfiddle: http://jsfiddle.net/mpusarla/sqoyds31/2/

Can you let me know if I am missing anything?

Thanks,
Madhu.

[paul....@gmail.com]

jExcel is aan alternative jquery plugin for handsontable. http://bossanova.uk/jexcel/working-with-dropdowns