Questions: How get select rows or columns index? about handsontable HOT 12 CLOSED

The method getSelected is now included in core. Thanks guys!

from handsontable.

To select rows or columns index use selectCell and specify the index. Example below to select the row/col 0,0

container.handsontable("selectCell", 0, 0);

The callback method described in Demo Page- Save

from handsontable.

Thank you for @azizasm !

I understand you are saying.
But I would like to know column and row index selecting now.

from handsontable.

This is how I've done it:

var selection = $("#exampleGrid").handsontable('getSelection');

selection is from col1,row1 to col2, row2

where

col1 = selection.start().col;
row1 = selection.start().row;

col2 = selection.end().col;
row2 = selection.end().row;

Hope that helps

from handsontable.

thanks @bruceh48 !

I tryed it but it occurred javaScript Error.
The details of Error: $(this).data("handsontable")[action] is undefined

Perhaps you could go into a little more detail.

from handsontable.

Oops my mistake..

I had forgotten that I had added an additional function to the handsontable.js file.

Its,
/**
* Returns the selection
*/
this.getSelection = function()
{
return selection;
};

I added it on line 2079, just after the function that starts with a line line that says :
this.selectCell = function

Without this, I could not "reliably" get the selection.

Its works well for me.

Hope that helps

from handsontable.

thanks @bruceh48 !

Mr. @warpech !
I'm glad you add above-mentioned @bruceh48 's code!
I beg your kindness.

from handsontable.

If you don't want to mess with the source code, all you really need is a little jQuery handler:

var rowIndex;
$('#yourTable tr').click(function () { rowIndex = $(this).index() });

You could modify this just a bit to capture a row select from one of the arrow keys as well.

from handsontable.

Hi guys, I have created a callback called onSelection. Use it as shown in http://warpech.github.com/jquery-handsontable/demo/conditional.html:

container.handsontable({
  ...

  onSelection: function(row, col, row2, col2) {
    var meta = container.handsontable('getCellMeta', row2, col2);
    if(meta.isWritable == false) {
      container.handsontable('updateSettings', {fillHandle: false});
    }
    else {
      container.handsontable('updateSettings', {fillHandle: true});
    }
  },

  ...
}

Do you think @bruceh48 method still would be handy? I am thinking about including it in the core

from handsontable.

thanks @warpech !
I've found what I want to do.

from handsontable.

@warpech

Yes, bruceh48's method would be very useful.

from handsontable.

@warpech @bruceh48

The code added by @bruceh48 has unpredictable behaviour depending on which direction the user makes his selection. For example: if the user makes a selection from a,b to c,d, he gets the coordinates (a,b), (c,d). However, if the user selects from b,c to a,d (the exact same area), he gets different coordinates.

The following code fixes this error and is intended to replace the code given by @bruceh48

this.getSelected = function() { 
    var x1 = selection.start().row;
    var y1 = selection.start().col;
    var x2 = selection.end().row;
    var y2 = selection.end().col;

    if( (x1 <= x2 && y1 < y2) || (x1 < x2 && y1 <= y2) || (x1 == x2 && y1 == y2)) {
        return [x1,y1,x2,y2];
    }
    else if( (x1 >= x2 && y1 > y2) || (x1 > x2 && y1 >= y2)) {
        return [x2,y2,x1,y1];
    }
    else if(x1 < x2 && y1 > y2) {
        return [x1,y2,x2,y1];
    }
    else if(x1 > x2 && y1 < y2) {
        return [x2,y1,x1,y2];
    }
};

The function $("#exampleGrid").handsontable('getSelected') now returns an array containing the coordinates, regardless of the direction of selection. [row1,col1,row2,col2]

I have have created a fork with this code in the appropriate place. See https://github.com/littley/jquery-handsontable

from handsontable.