Paste without formatting not working in Google Docs
-
@Gwen-Dragon I do appreciate the update, though the lack of progress is unfortunate...this seems fundamental for so many users / potential users.
@Hadden89 see this video: https://drive.google.com/open?id=1HQXUIA2qDchSelAH8FuH1YvydOeHs177
-
@Gwen-Dragon - can you confirm you can do the following? I still cannot in 3.4.2066.90 on Win 10 x64:
-
Create a new Google Sheets file
-
Enter a number into a cell
-
Format that number in some way (bold, color, whatever)
-
Copy the cell
-
Now create a (second) new Google Sheets file
-
Regular paste. The cell from the first file comes through fine - formatting and all
-
Now attempt to paste values. It does not work. Nothing gets pasted. Neither Ctrl+Shift+V nor using the menu (Edit / Paste Special / Paste values only)
This is a common use case for any regular Sheets user. We need to be able to bring over unformatted values from one file to another. Try the same in Chrome (or any other browser) - works just fine.
Thanks for your follow up
-
-
@Gwen-Dragon I just downloaded 3.5.2088.7 Snapshot and tried it there, but the bug still remains for me.
Just to be clear, you are copying a cell from Sheets file 1 and then attempting to "paste values only" into Sheets file 2? That is the crux of it - paste values does not work when going to a separate file
-
Somehow Ctrl+Shift+V on Google Docs or spreadsheet pastes clipboard content to Google search sometimes. (face palm). I don't want to give my clipboard content to Google...
-
@jae said in Ctrl+Shift+V to paste without formating on google sheets not working on Vivaldi:
It doesn't make sense to me, why are you using Google Docs at all then, if you're so concerned to not giving Google anything? You are giving already to Google all they want to know about your browsing habits. Make up your mind about your priorities -
@iAN-CooG I will tell you what's the difference. Content in my Google Docs is processed by machines and it does check the spelling and grammar and so on, but humans won't see it. But the search queries are anonymized and used for search quality improvement. Human workers won't know who exactly searched it. But if the query is very specific long enough text, there might be information leak to humans workers. The query itself may be identifiable by the query itself even though it's anonymized.
There's no need for humans to see Google Docs contents, so it's not justified at all. I'm pretty sure the access is blocked, but even though someone accesses it, it's audited and they will get fired. But search queries can be researched with queries like (just an example) "show me queries that triggered news section at top but the quality metric is bad" to research what's going on, then those queries may show up.
-
I think it's a really bad idea to make "Ctrl+Shift+V" to do search with the clipboard. It's very easy to make mistake when pasting text, and sometimes browser takes the action instead of the web app.
-
@jae Not getting into whether it should be default or not, to fix this on your install, you should remove that keyboard combo in settings.
Go to
Settings
โKeyboard
โWindow
โPaste and Go
and remove the default entry ofCtrl
+Shift
+V
. -
@nomadic Thank you so much! You saved my life. As a user from Opera 6.06, I thought there should be an option for this. Just couldn't find it somehow. I'm a dumbass.
-
I tested now - ctrl+shift+v (paste without formatting) still not working in google spread sheets :(. Works in google documents but not in sheets.
Windows 10 Pro, Vivaldi 3.5.2115.87
-
https://www.autohotkey.com/ helps with script:
^+v:: clipboard = %clipboard% Send ^v return
-
@charlie1212 https://www.autohotkey.com/ helps with script:
^+v::
clipboard = %clipboard%
Send ^v
returnThen ctrl+shift+v (paste without formatting) works in vivaldi.
-
@Gwen-Dragon still not working for me in 3.6.2165.32 (Official Build) (64-bit)
@kohy I appreciate that tip, but this is core Google Apps functionality...it's actually a menu item (Edit / Paste Special / Paste Values Only)...should not require a hack to work
-
@kohy You really made my day. It working fine now even in the incognito tab.
-
@charlie1212
It doesn't work for me and I agree with you. It's an important issue.
I was testing Vivaldi to be my standard browser, but I'm quitting the idea because of that. -
@charlie1212 said in Paste values in Google apps *still* not working:
Create a new Google Sheets file
Enter a number into a cell
Format that number in some way (bold, color, whatever)
Copy the cell
Now create a (second) new Google Sheets file
Regular paste. The cell from the first file comes through fine - formatting and all
Now attempt to paste values. It does not work. Nothing gets pasted. Neither Ctrl+Shift+V nor using the menu (Edit / Paste Special / Paste values only)
4.1.2369.11 Pasting unformatted with Ctrl+Shift+V works for me now.
-
@doctorg Hi
It's not working for me. Tested it just now.
When I copy data from an Excel spreadsheet and paste as values in a Google sheet, it simply doesn't work. It pastes the previous item from the transfer area, but not the current one. -
@felipe12345 Yes, copying formatted text from external app like LibreOffice Calc or MS Excel and paste into browser as raw text fails.
But this happens on Chromium, too. Not a Vivaldi issue, i think. I have not tested with Edge or Firefox or Chrome.Please tell me: copy from Excel to Google Sheets cell running browser works with which browser?
-
@doctorg It works fine in Chrome
-
This post is deleted!