🐛 Bug: Copying and pasting from Excel overwrites one additional row

[halphalp]

🐛 Bug: Copying and pasting from Excel overwrites one additional row

[dstala]

tried copying from a Google spreadsheet, unable to reproduce. Can you confirm if you by mistake didn't copy one extra empty cell? you can paste us a video of this issue. would help us.

Haven't tried using MS Excel though

[halphalp]

tried copying from a Google spreadsheet, unable to reproduce. Can you confirm if you by mistake didn't copy one extra empty cell? you can paste us a video of this issue. would help us.

Haven't tried using MS Excel though

I'll try to record something, but I can confirm this has happened multiple times when loading data. If it helps, I copied from Excel to NocoDB in Microsoft Edge.

[o1lab]

Could you please try it in chrome or others once.

[halphalp]

Could you please try it in chrome or others once.

Can confirm it's also happening in Chrome. I select two cells in Excel, copy, click a single cell in NocoDB, right click > paste, it pastes the two cells and highlights a third (the row underneath the paste) and clears its contents.

[xtyuns]

the same question，When the content copied from desktop version of Excel exceeds 1 column, you will also encounter an error message from the front end.

step1: create a table

step2: copy from excel

step3: paste in table

[xtyuns]

The reason for this problem is that clipboardData always ends with \n.

So when you select 2 columns from Excel copy and paste them into nocodb, it will produce an extra row with only one column