Page 1 of 1

SHEET add row dynamically

Posted: 01 Nov 2018, 15:43
by kimg
Is there a way to detect that the cursor is in the last row and the last cell in the sheet?

I would like to add another empty row to the sheet when the user press TAB in the last columns last cell.
IS there an example on how to do this?
Today the cursor goes to the first cell in the first row.

I'm aware of the 'dynamics colums' context menu in which you add a new row. but i would like to do this with the method described above.

Kim

Re: SHEET add row dynamically

Posted: 01 Nov 2018, 16:02
by Melloware
You will need to use custom JS to accomplish this like we do with the Context Menu example or "Extender". To get what you need to do to make TAB Insert a Row I suggest asking someone on the HandsonTable forums. They probably will be able to help you with the JS.

https://forum.handsontable.com/

Re: SHEET add row dynamically

Posted: 01 Nov 2018, 16:57
by kimg
Thank you.
I will try that and post a solution here.... :-)

Re: SHEET add row dynamically

Posted: 01 Nov 2018, 17:20
by Melloware
Definitely let us know what you come up with!