Handson table pasting data issue

Tags: #<Tag:0x00007f1360624f10> #<Tag:0x00007f1360624dd0>
#1

Whenever I am trying to copy and paste any cell data into another it will shift all the column data of selected cell one down. Please help me out with this I want normal copy paste behaviour in my handson table.
For example if i have table with 10 rows and I am copying some text and pasting in any of the cell it will shift all data one down and now we are having table with 11 rows.

IMG_2612
IMG_2612.png2532×1170 111 KB

#2

Hi @sandeep.verma100891

The behavior that you are describing sounds like you have some custom logic in one of the following hooks

  • beforeChange, afterChange
  • beforePaste, afterPaste

applied, or you have set the pasteMode to shift_down. Reference: https://handsontable.com/docs/javascript-data-grid/api/copy-paste/#pastemode

12

Here https://jsfiddle.net/7tmsz625/ we have a table with default set (pasteMode: 'overwrite'), that overwrites the data instead of shifting the existing data to other rows/columns.

#3