Prevent Adding Columns Automatically

Tags: #<Tag:0x00007f8b19c62680>
#1

I am using handsontable 9.0.2 version in vue2.
If you are using only 2 columns and you copy and paste more than 2 columns, the columns are automatically added. What should I do to stop this??

image

#2

Hi @gogokye

Generally, it’s how it should work, as spreadsheets should be expanded by design. However, you can block this behavior by setting maxCols value. Here’s an example:

https://jsfiddle.net/aszymanski/8g714yxn/

#3