Note: This is on MacOS. I don't know if it is repeatable on Windows.
When I copy a cell to a text editor and back, formatting (and links) are preserved. Even links, while don't appear in the text editor, reappear in Google Spreadsheet.
1. Open a Google Spreadsheet. 2. Choose an empty cell and paste a hyperlink formula, i.e.: =HYPERLINK("http://www.google.com/","Google") 3. Copy cell content (Mark cell, then CMD+C). 4. Open TextEdit. 5. Switch to plain text (CMD+Shift+T). 6. Paste cell content (CMD+V). 7. Copy content from text (Mark text, then CMD+C). 8. Go back to Google Spreadsheets and choose and empty cell. 9. Paste text (CMD+V).
BTW, I have tried pasting to Google Docs and it doesn't preserve formatting/link.
What makes this work?
Is it configurable?
EDIT: Performing "Paste and Match Style" (⌥+⇧+⌘+V) in step 6, with or without skipping step 5, didn't make any difference.