Closed Bug 1427462 Opened 7 years ago Closed 2 years ago

"Paste Special" doesn't work in Google Sheets

Categories

(Web Compatibility :: Desktop, defect, P1)

Firefox 57
Desktop
Unspecified
defect

Tracking

(Webcompat Priority:?, firefox78 affected, firefox101 affected)

RESOLVED DUPLICATE of bug 1640222
Webcompat Priority ?
Tracking Status
firefox78 --- affected
firefox101 --- affected

People

(Reporter: baconcatbug, Assigned: ksenia)

References

()

Details

(Keywords: webcompat:site-wait)

Attachments

(2 files)

User Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0 Build ID: 20171226083017 Steps to reproduce: Open Excel/Libreoffice Spreadsheet Open Google Sheet Copy Data from Excel/Libreoffice Spreadsheet Attempt to Paste Special > Values only via right click menu Actual results: Nothing happens. Pasting normally works but overrides the formatting. Expected results: It should paste the values and not change the formatting
Component: Untriaged → Desktop
Product: Firefox → Tech Evangelism
Version: 57 Branch → Firefox 57
Flags: needinfo?(sergiu.logigan)
Flags: needinfo?(sergiu.logigan)
Priority: -- → P1
I can reproduce this on Windows 10 and Nightly 61. Not reproducible on Chrome 66. Tried "pasting values only" from Libre Office into a newly created Google Sheet.
Status: UNCONFIRMED → NEW
Ever confirmed: true
Product: Tech Evangelism → Web Compatibility
Attached image paste-special-menu (deleted) —

The menu has many options.

The special menu gives the possibility to copy only the style information or the values stripping the style.
The command V gives the style by default.

There's one thing which is interesting.

To reproduce.

  1. In A1 Type a word: MOZILLA
  2. select the cell A1
  3. Copy with keyboard combinations (command + C, Ctrl +C)
  4. Go to A2
  5. paste
  6. We get Mozilla
  7. In an app outside of Google Sheets, select and copy a text. (ex: I selected code)
  8. Go to A3
  9. paste
  10. We get code
  11. Go to A4
  12. paste special -> Values only
  13. we get MOZILLA (instead of code). Google kept another memory for the paste special function.

This is probably the issue.

Status: NEW → RESOLVED
Closed: 4 years ago
Resolution: --- → FIXED
Status: RESOLVED → REOPENED
Webcompat Priority: --- → ?
Resolution: FIXED → ---

I have contacted them

Attached image results of paste (deleted) —

Sorry, should have realized when first reported.

Ultimately, this relies on programmatic ability to read the clipboard to resolve this case. The Paste special menu is owned by Sheets and would need to trigger a paste in order to get up-to-date clipboard content outside of the application.

In the past, this API has not been available. Is this API now available in FF to programmatically trigger a paste?

I was able to reproduce the issue. Use the right-click command Paste Special-> Values Only, no result is returned:

https://media.giphy.com/media/2s5Jb4MLcvM4OJQLX6/giphy.gif

Tested with:

Browser / Version: Firefox Nightly 101.0a1 (2022-04-07) (64-bit)/ Chrome Version 100.0.4896.75 (Official Build) (64-bit)
Operating System: Windows 10 PRO x64

Notes:

  1. Reproducible regardless of the status of ETP.
  2. Reproducible on the latest build of Firefox Nightly.
  3. Works as expected using Chrome.
  4. Possible duplicate: https://bugzilla.mozilla.org/show_bug.cgi?id=1640222
Assignee: nobody → kberezina
Status: REOPENED → ASSIGNED
Hardware: Unspecified → Desktop

Let's close this as a duplicate of https://bugzilla.mozilla.org/show_bug.cgi?id=1640222

Status: ASSIGNED → RESOLVED
Closed: 4 years ago2 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: