Copying text from Excel to Grist often results in Line Breaks (a problem specially if it's a reference)

Ask for Help
1

image
image504×565 7.08 KB

when copying and pasting into Grist, some rows stay correct (and the reference links) while others for some reason get line breaks
image

It seems it’s a Grist think, because when copying and pasting into Notepad++, it works very well.

Then from Notepad++ to Grist it works fine too. But of course, Notepad ++ doesnt have columns, so I would need to copy and paste column by column.

1 Like
2

Hi, did you find a solution?

3

No. Only importing works, not copying.

4

I have the same problem here. For now I put trigger formula to remove extra blanks and line breaks in the columns where I need to copy from Excel.

5

Thanks! I don’t have the problem if paste without format ctrl+shiv+V . But hard to make sure that end users will do that :slight_smile:

6

ctrl+shift+v works? Hmmmm… interesting. Will try that.