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

[halphalp]

Please confirm if bug report does NOT exist already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

1. Copy values from Excel
2. Select a location in a NocoDB table to paste
3. Paste the values and note that the row after the last pasted row has its value erased

Essentially, if I copy 5 cells from Excel and paste them into rows 1-5 in a NocoDB table, the value in the column I'm pasting for row 6 will be erased if it exists.

Desired Behavior

Only update the rows being pasted - not beyond.

Project Details

Node: v20.11.1
Arch: x64
Platform: linux
Docker: true
RootDB: pg
PackageVersion: 0.205.1

Attachments

No response

[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