Bug 151864 - Paste Special [No selection possible] when copying text from a web browser
Summary: Paste Special [No selection possible] when copying text from a web browser
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.1.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste-Special
  Show dependency treegraph
 
Reported: 2022-11-02 11:58 UTC by Ryan Sarson
Modified: 2023-11-02 15:15 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ryan Sarson 2022-11-02 11:58:40 UTC
Description:
When trying to copy text into Calc using Paste Special, I expect to see the context menu (specifically to select "Unformatted Text") but instead I see a greyed out "[No selection possible]".  If I close the file and reopen it, the menu becomes available again

Steps to Reproduce:
1. open a file in Calc
2. highlight text from a website and copy it with ctrl-c (for example, choose a week's worth of scores from https://www.footballdb.com/games/index.html)
3. right-click a cell and hover over "Paste Special" and see a greyed out "[No selection possible]"
4. close Calc
5. reopen the file in Calc
6. right-click a cell and hover over "Paste Special" and now see the expected context menu

Actual Results:
can't paste copied data into calc without having to reload the file

Expected Results:
option to paste unformatted text into calc without having to reload the file


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
i can't pinpoint exactly when this bug happens... after i reload the file, i can't reproduce it right away.  it normally happens each week when i update my football pool spreadsheet, so i'm guessing it has something to do with the timing between using the clipboard and the initial loading of calc and/or my web browser into memory

also, next week i will attempt to use the ctrl-alt-shift-v keyboard shortcut while seeing '[no selection possible]' to see if that works before reloading the file
Comment 1 m_a_riosv 2022-11-02 22:08:45 UTC
I can't reproduce the issue.
Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 2 michele.petrazzo 2022-11-04 07:35:01 UTC
Hi,
same problem here, but not only on Calc, everywhere in LibO.

Distributor ID: Ubuntu
Description:    Ubuntu 22.04.1 LTS
Release:        22.04
Codename:       jammy

Operating System: Kubuntu 22.04
KDE Plasma Version: 5.25.5
KDE Frameworks Version: 5.98.0
Qt Version: 5.15.3

Version: 7.4.1.2 / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Linux 5.18; UI render: default; VCL: kf5 (cairo+wayland)
Locale: it-IT (it_IT.UTF-8); UI: en-US

Steps to Reproduce:
1. open a file in LibO (Calc or Writer or Impress or ...)
2. highlight text from whatever you want and copy it with ctrl-c. Try first: a) clean text (for example with Notepad -Win- or Kate/Vim -Linux-) and after b) a website (for example this bugzilla site in the top of page "Bug 151864 - Paste Special [No selection possible] when copying text from a web browser (edit)")
3a. go to LibO and past with "ctrl-shift-v" the clean text. The "paste special" dialog is shown with only the choice "unformatted text"
3a. go to LibO and past with "ctrl-shift-v" the web site text. The "paste special" dialog is shown with two choices "HTML and unformatted text".
4. on both case, press "OK" to past and a new dialog is shown with "Requested clipboard format is not available." and no text is pasted.

The only possibility to past a text is to:
5. past with ctrl-v (if the text is formatted, LibO receive the format with "url, bold, ..."), and if you want to clean up the text format, you have to:
6. copy another time the same text, but within LibO 
7. paste special "ctrl-shift-v" and now the "paste special" dialog show you a very complete dialog with "libo text document, rtf, html, unformatted text, dde link".
8. now the "ok" functions works and you can choose whatever format you want

At the end, I think that from 7.4 version LibO can read only its own clipboard format into the "special paste" dialog
Comment 3 Buovjaga 2023-02-27 13:22:28 UTC
Set to NEW per the previous comment, but it would be interesting to hear if Ryan and Michele still experience this with 7.5.

Ryan: Please copy and paste here the contents of your Help - About (LibreOffice - About on macOS) by clicking the copy button. This allows us to know more about your system.
Comment 4 michele.petrazzo 2023-02-27 15:27:12 UTC
(In reply to Buovjaga from comment #3)
> Set to NEW per the previous comment, but it would be interesting to hear if
> Ryan and Michele still experience this with 7.5.
> 
> Ryan: Please copy and paste here the contents of your Help - About
> (LibreOffice - About on macOS) by clicking the copy button. This allows us
> to know more about your system.

Hi Buovjaga,
yes, just tried and the behaviour (and the error) is the same

Bye
Comment 5 Gauthier 2023-06-04 11:02:40 UTC
might be related to Bug 68765 ?
Comment 6 Ryan Sarson 2023-11-02 11:02:15 UTC
Some additional info:

This bug happens if the web browser is opened before calc is opened.  It does not happen if calc is opened before the web browser is opened.
Comment 7 Stéphane Guillou (stragu) 2023-11-02 11:19:54 UTC
(In reply to Ryan Sarson from comment #6)
> Some additional info:
> 
> This bug happens if the web browser is opened before calc is opened.  It
> does not happen if calc is opened before the web browser is opened.

That's useful info but please see comment 3 for version information. Its important to know which OS and desktop environment your are using, especially for clipboard issues.
Comment 8 Ryan Sarson 2023-11-02 11:21:41 UTC
Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 2; OS: Linux 4.9; UI render: default; VCL: x11
Locale: en-CA (en_CA.UTF-8); UI: en-GB
Debian package version: 4:7.4.7-1
Calc: threaded