How to disable copy n-columns but paste to n+ columns

Getting help Questions
1

If you highlight two columns then copy to clipboard, but you then select four columns to paste, the data that you copied from the two columns will then paste into all four columns. Is there a way to disable this so that if the user accidentally highlights more columns to paste into than they selected to copy, that it will only paste the same number of columns that they copied into their clipboard?

2

Hi @jerry

you can block an ability to populate columns while pasting via beforePaste hook. Here’s a demo http://jsfiddle.net/8Lpmy7fj/1/