Search code examples
javascriptexcelgetselectionhandsontable

Handsontable - getSelected not working


I'm using handsontable to create some excel-like spreadsheets and I need to retrieve the data selected by the user to create a chart using gRaphael. But when I try to even alert the data selection parameters using this code:

var ht = $('#dataTable0').data('handsontable');
var sel = ht.getSelected();
alert(sel[0]);

I get 'undefined' written in the alert window. Can someone tell me how to fix this code?


Solution

  • Your code is obsolete, which may be the reason it doesn't work as intended. The recommended way if you are using the latest version 0.9.7 is:

    $('div#example1').handsontable(options);
    
    //get the instance using jQuery wrapper
    var ht = $('#example1').handsontable('getInstance');
    
    //Return index of the currently selected cells as an array [startRow, startCol, endRow, endCol]
    var sel = ht.getSelected();
    
    //'alert' the index of the starting row of the selection
    alert(sel[0]);
    

    If you are using an older version I suggest downloading the latest version.

    EDIT:

    As suggested by @polras, you can also add:

    outsideClickDeselects: false 
    

    to handsonetable options