Is there a property or feature in handsontable that will disallow paste into the handsontable grid?

Getting help Questions
1

I have a fixed size grid in handsontable, with 2 columns and 2 rows. But when i copy data from an excel which has more number of columns and rows, into the handsontable grid, the grid gets expanded with the new data. is there a way to disallow this feature?

2

Hi @minal

Yes, you can control this behavior if you know that you need 2 rows and 2 columns. You can use maxCols and maxRows - here’s an example for the 2x2 array https://jsfiddle.net/AMBudnik/q1harumc/

3

Thanks for the help @aleksandra_budnik