X
Tap here to go to the mobile version of the site.

منتدى الدعم

Google Spreadsheet paste doesn't work

Posted

I have recently given up my Microsoft office account, and when needing to share a spreadsheet I'm now using Google Spreadsheet though the web browser, but when I try and paste into a google spreadsheet using the right click mouse button menu I get a popup https://cdn.discordapp.com/attachments/357648397920108548/621073069493977088/unknown.png that says copying and pasting in google docs, these actions are unavailable using the edit menus, but you can still use ctrl+c for copy ctrl+x for cut ctrl+v for paste, but when i use the control+v for paste i get and empty cell with a little clipboard menu https://cdn.discordapp.com/attachments/357648397920108548/621073154416050189/unknown.png that I then have to click on to open a drop down box that says paste values only/paste format only/split text to columns https://cdn.discordapp.com/attachments/357648397920108548/621073203711705119/unknown.png .

It works fine in chrome, it works fine in edge, but firefox is a no go, how do I fix this?

I have recently given up my Microsoft office account, and when needing to share a spreadsheet I'm now using Google Spreadsheet though the web browser, but when I try and paste into a google spreadsheet using the right click mouse button menu I get a popup https://cdn.discordapp.com/attachments/357648397920108548/621073069493977088/unknown.png that says copying and pasting in google docs, these actions are unavailable using the edit menus, but you can still use ctrl+c for copy ctrl+x for cut ctrl+v for paste, but when i use the control+v for paste i get and empty cell with a little clipboard menu https://cdn.discordapp.com/attachments/357648397920108548/621073154416050189/unknown.png that I then have to click on to open a drop down box that says paste values only/paste format only/split text to columns https://cdn.discordapp.com/attachments/357648397920108548/621073203711705119/unknown.png . It works fine in chrome, it works fine in edge, but firefox is a no go, how do I fix this?
Quote

Additional System Details

Installed Plug-ins

u block origin pcloud save bitwarden bitly grammerly chrome store foxfied and the google open app

Application

  • User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:69.0) Gecko/20100101 Firefox/69.0

More Information

jscher2000
  • Top 10 Contributor
8637 solutions 70654 answers

Hi Listatta, unless you are pasting white text onto that white background, I don't know why it's invisible. If you select Paste values only, does the text show up?

Sheets is a complex application, so we often have to live with what Google gives us.

For the most basic pasting, if you double-click the cell and then paste, it should go in as plain text.

But for pasting a range of cells or preserving formatting, the results are less predictable.


By the way, you can set Firefox to show its own right-click menu on sites that replace it. Here's where to change the setting:

(1) In a new tab, type or paste about:config in the address bar and press Enter/Return. Click the button promising to be careful or accepting the risk.

(2) In the search box above the list, type or paste context and pause while the list is filtered

(3) Double-click the dom.event.contextmenu.enabled preference to switch the value from true to false

Using Paste on Firefox's menu should still work, even though it doesn't work on Google's custom menu.

To "peel off" Firefox's menu from in front of the site's menu, you can tap the Alt key. It's an individual judgment whether having that menu when you need it justifies the inconvenience of sometimes having to peel it off.

Hi Listatta, unless you are pasting white text onto that white background, I don't know why it's invisible. If you select Paste values only, does the text show up? Sheets is a complex application, so we often have to live with what Google gives us. For the most basic pasting, if you double-click the cell and then paste, it should go in as plain text. But for pasting a range of cells or preserving formatting, the results are less predictable. ---- By the way, you can set Firefox to show its own right-click menu on sites that replace it. Here's where to change the setting: (1) In a new tab, type or paste '''about:config''' in the address bar and press Enter/Return. Click the button promising to be careful or accepting the risk. (2) In the search box above the list, type or paste '''context''' and pause while the list is filtered (3) Double-click the '''dom.event.contextmenu.enabled''' preference to switch the value from true to false Using Paste on Firefox's menu should still work, even though it doesn't work on Google's custom menu. To "peel off" Firefox's menu from in front of the site's menu, you can tap the Alt key. It's an individual judgment whether having that menu when you need it justifies the inconvenience of sometimes having to peel it off.
Was this helpful to you?
Quote

Question owner

"if you double-click the cell and then paste," paste via right click or paste via ctrl+v doesn't work either way.

so those are not white text on white backgrounds, it's EMPTY.

right click only gives me that stupid pop up window

control+v gives me that empty cell, with the little clipboard icon and it won't paste anything until I click on that little clip board, and then click on format or values, and i can't ever have both, just one or the other, and if I paste value and then try and come back and past format, it erases the previous values.

That it works fine in chrome AND edge, but not in firefox, (tested 2 different computers) with same results is just.....

edge can do it and firefox can't?! without having to re-write the shortcut for all of google docs?!

"if you double-click the cell and then paste," paste via right click or paste via ctrl+v doesn't work either way. so those are not white text on white backgrounds, it's EMPTY. right click only gives me that stupid pop up window control+v gives me that empty cell, with the little clipboard icon and it won't paste anything until I click on that little clip board, and then click on format or values, and i can't ever have both, just one or the other, and if I paste value and then try and come back and past format, it erases the previous values. That it works fine in chrome AND edge, but not in firefox, (tested 2 different computers) with same results is just..... edge can do it and firefox can't?! without having to re-write the shortcut for all of google docs?!
Was this helpful to you?
Quote

Question owner

By the way, you can set Firefox to show its own right-click menu on sites that replace it. Here's where to change the setting:

(1) In a new tab, type or paste about:config in the address bar and press Enter/Return. Click the button promising to be careful or accepting the risk.

(2) In the search box above the list, type or paste context and pause while the list is filtered

(3) Double-click the dom.event.contextmenu.enabled preference to switch the value from true to false

Using Paste on Firefox's menu should still work, even though it doesn't work on Google's custom menu.

To "peel off" Firefox's menu from in front of the site's menu, you can tap the Alt key. It's an individual judgment whether having that menu when you need it justifies the inconvenience of sometimes having to peel it off. </blockquote>

This does not work and only does the following: click right: see attached image below, but there is no paste option ctrl+v: exact same result as before little stupid clipboard icon

By the way, you can set Firefox to show its own right-click menu on sites that replace it. Here's where to change the setting: (1) In a new tab, type or paste '''about:config''' in the address bar and press Enter/Return. Click the button promising to be careful or accepting the risk. (2) In the search box above the list, type or paste '''context''' and pause while the list is filtered (3) Double-click the '''dom.event.contextmenu.enabled''' preference to switch the value from true to false Using Paste on Firefox's menu should still work, even though it doesn't work on Google's custom menu. To "peel off" Firefox's menu from in front of the site's menu, you can tap the Alt key. It's an individual judgment whether having that menu when you need it justifies the inconvenience of sometimes having to peel it off. </blockquote> This does not work and only does the following: click right: see attached image below, but there is no paste option ctrl+v: exact same result as before little stupid clipboard icon
Was this helpful to you?
Quote

Question owner

so here is a screen capture of something I'm trying to copy: https://cdn.discordapp.com/attachments/617285752450973699/621125354337075201/unknown.png as you can see I've selected that one and I've right clicked and copied

when I go to the new spreadsheet and past via ctrl+v i get: https://cdn.discordapp.com/attachments/617285752450973699/621125312478183443/unknown.png and I have to open the clip board click on values and then finally it gets pasted

so here is a screen capture of something I'm trying to copy: https://cdn.discordapp.com/attachments/617285752450973699/621125354337075201/unknown.png as you can see I've selected that one and I've right clicked and copied when I go to the new spreadsheet and past via ctrl+v i get: https://cdn.discordapp.com/attachments/617285752450973699/621125312478183443/unknown.png and I have to open the clip board click on values and then finally it gets pasted
Was this helpful to you?
Quote
jscher2000
  • Top 10 Contributor
8637 solutions 70654 answers

Thanks for the example. I don't know why that content is invisible when pasted into Google Sheets. There probably is a difference in how Firefox copies that to the clipboard and how other browsers do it. For example, Firefox doesn't include externally defined styles.

Is the source website a public page you can link to? If not, I guess use a different browser, or look for any other threads about how to work around it on that site.

Thanks for the example. I don't know why that content is invisible when pasted into Google Sheets. There probably is a difference in how Firefox copies that to the clipboard and how other browsers do it. For example, Firefox doesn't include externally defined styles. Is the source website a public page you can link to? If not, I guess use a different browser, or look for any other threads about how to work around it on that site.
Was this helpful to you?
Quote
اطرح سؤالا

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.