I want a new row (empty row) always exists at the end of the handsontable, no matter whether after the table have loaded the data nor after the table have just saved a new record.Thus, users can always enter a new record on the new row, without the need to always insert row below by context menu.
I have tried to set the minSpareRows property as 1 to achieve the above requirement, but if the table load more rows than last time, the empty row will display in the middle of the table, for example, last time I have loaded 2 rows in the table, and this time I want to load 10 rows, there is a needless empty row display at line 3, and also a spare row display at line 11, it seems odd.
Please how should I do to achieve the goal? thanks.
This issue is also caused by ‘hiddenColumns’ option, as in the demonstrate: http://jsfiddle.net/kailkailin/g5ga4L1q/ . Please help us to fix the issue asap, thank you very much!
Thank you very much for the demo @kailin.lu
It’s definitely a bug - you can try to initialize minSpareRows after loadData()http://jsfiddle.net/zwe5ghsc/.
I do not know if this solution is accurate for your project - when you actually load extra data (by a click, after some events).