I’ve got a cell with email addresses populated by a formula. I use CTRL-C or right-click-Copy to put the addresses on the clipboard. If I use a new line character to separate the email addresses in a text string, when I paste it, I get a double quote before and after the addresses. If I use any other character (e.g., comma, semicolon) in place of the new line character, I don’t get the double quotes.
How do I stop the double quotes?
example:
"Scott Rosenthal scott@sltf.com
"
Hey Scott!
Copying to the clipboard in Grist is intended to match the behavior of Excel and Sheets. When copying data to the clipboard, it copies it in multiple formats. The format that gets used for pasting depends on the application you’re pasting in. If you double click into the cell so it opens into ‘Edit’ mode, then copy the text, it will paste without the double quotes.
Thanks,
Natalie
That doesn’t work in my case. The problem is that my Grist column is a formula that creates the list. Double-clicking opens the formula editor, which isn’t the data I want to copy.
Hi @Scott_Rosenthal.
There’s a custom widget that lets you copy column values with a click. You can add it to the same page as your table and link the two. Does that work for your use case?
George
Thanks, but that won’t work. I have many rows with different information and each column’s cell needs copying (e.g., CTRL-C or right-click/Copy). A single “Copy to Clipboard” widget won’t suffice.
Here’s an image of the different cells I want to individually copy to the clipboard:
