Download it now!
Bug 136762 - LibreOffice does not paste after v7
Summary: LibreOffice does not paste after v7
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.0.alpha0+
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency treegraph
 
Reported: 2020-09-14 22:55 UTC by BikeHelmet
Modified: 2020-10-20 04:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
InsideClipboard - Contents Example (7.35 KB, image/png)
2020-09-25 09:24 UTC, BikeHelmet
Details
InsideClipboard - Contents Example (4.37 KB, image/png)
2020-09-25 09:24 UTC, BikeHelmet
Details

Note You need to log in before you can comment on or make changes to this bug.
Description BikeHelmet 2020-09-14 22:55:26 UTC
Description:
Paste is no longer a feature in Calc on my computer.

Steps to Reproduce:
1. Reboot computer.
2. Open LibreOffice Calc.
3. Open a website.
4. Copy some text or a forum post.
5. Go to LibreOffice and try to paste. Try the menu, try right-click -> Paste, try Ctrl+V and Ctrl+Shift+V
6. Go to Notepad++ and paste the text, no problem.
7. Go to Notepad and paste the text, no problem.
8. Copy the text from Notepad++ and from Notepad.
9. Go to LibreOffice and try to paste. Try the menu, try right-click -> Paste, try Ctrl+V and Ctrl+Shift+V

Actual Results:
Nothing pasted into Calc.

Expected Results:
Clipboard contents pasted into Calc.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
You can highlight the text and drag-and-drop it into Calc, but Paste itself doesn't work. Bizarre.

If I downgrade to v6.4.x it seems to work again, though pasting does break repeatedly after a couple pastes, and then is fixed by saving and using "Reload" on the document/spreadsheet.

I do have Ditto installed - a possible factor, though it does not interfere with anything else. I have tried turning it off and got the same results.
Comment 1 V Stuart Foote 2020-09-15 16:50:51 UTC
OP says clipboard holds content made available to other applications. Just not picked up for paste into a LO calc cell.

So Needinfo to OP as to the same content copied--but then behavior of LO Paste or Paste Special into a different LO module, i.e. Writer or Impress?

Maybe use a clipboard utility (e.g. Nirsoft's InsideClipboard) and see what formats your Windows shell is holding on the clipboard, and the priority--done with and without the 'Ditto' utility enabled.

Suspect to be a dupe of bug 62196, don't think there has been an substantive work on clipboard contents 6.4 -> 7.0

@Mike K.?
Comment 2 Mike Kaganski 2020-09-15 16:53:22 UTC
(In reply to V Stuart Foote from comment #1)
> don't think there has been an substantive work on clipboard contents 6.4 -> 7.0

That is also my perception.
Comment 3 BikeHelmet 2020-09-25 09:24:09 UTC
Created attachment 165828 [details]
InsideClipboard - Contents Example
Comment 4 BikeHelmet 2020-09-25 09:24:44 UTC
Created attachment 165829 [details]
InsideClipboard - Contents Example
Comment 5 BikeHelmet 2020-09-25 09:39:44 UTC
So I have been digging into it, and it seems almost like LibreOffice doesn't initialise something required for pasting until later. My workflow involves opening a document and pasting data into it, and something snags that up.

I happened to leave a spreadsheet open over lunch - before lunch it wasn't pasting the clipboard contents, and I was getting ready to retype the info. After lunch it worked fine.

Investigation: I opened a new document and tried to paste some text (CF_TEXT, CF_UNICODETEXT), some gmail HTML (HTML Format), paste special, etc. - absolutely nothing. Then I waited. And waited. After about 5 minutes, a green progress bar appeared at the bottom of the window and flashed by, and suddenly pasting worked again. It closely resembled the Save progress bar, which made me wonder if I just witnessed it autosaving.

So to test that, I opened another spreadsheet and made some changes and told it to save... no green progress bar. No save. I tried the menu, Ctrl+S hotkey, etc. - nothing happened despite the spreadsheet having been modified. Then after a while a green progress bar appeared, the file modified date changed in explorer, and suddenly I could save at will going forward - and also paste.

So my theory has changed to some component not initialising quickly, timing out, and blocking both pasting and saving much of the time. A real mystery, which is strongly tempting me back to 6.4.6

Is there any other info that I can get, or diagnostics/commands to run which might provide useful info?

Right at this exact moment, when I open new spreadsheets with old ones already open, they seem to be behaving... though if I reboot, they won't be behaving properly anymore.
Comment 6 V Stuart Foote 2020-09-25 13:37:04 UTC
(In reply to BikeHelmet from comment #5)

Unfortunately the InsideClipboard clips don't identify the application(s) with lock on the clipboard--the clipboard owner, which likely is not LibreOffice.

https://docs.microsoft.com/en-us/windows/win32/dataxchg/clipboard?redirectedfrom=MSDN
 
> 
> So my theory has changed to some component not initialising quickly, timing
> out, and blocking both pasting and saving much of the time. A real mystery,
> which is strongly tempting me back to 6.4.6
> 

Sure that is likely... but could also be a 3rd party app holding the Windows clipboard--locking out LibreOffice. 

> Is there any other info that I can get, or diagnostics/commands to run which
> might provide useful info?
> 
> Right at this exact moment, when I open new spreadsheets with old ones
> already open, they seem to be behaving... though if I reboot, they won't be
> behaving properly anymore.

So as in the see also bug 62196#c28 -- what else on your system could be intefering with LireOffices Windows clipboard interface to the LO Xclipboard core?

You mention "Ditto", had you eliminated that from the configuration?  To provide meaningful Steps to Reproduce, you really need to isolate the system to Windows - LibreOffice - and the "source" of the clipboard content (e.g. a specific web browser). Other apps/utils should be shutdown.
Comment 7 BikeHelmet 2020-10-05 09:50:30 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2020-10-06 03:45:12 UTC Comment hidden (obsolete)
Comment 9 BikeHelmet 2020-10-19 21:01:51 UTC
(In reply to BikeHelmet from comment #7)
> Yes, I eliminated Ditto.
> 
> I still have lots of background software running, though. Short of going
> into Safemode, I don't think I can disable it all?
> 
> I just observed the behaviour again - I copied some numbers from Gmail into
> the Calculator, multiplied them, then copied them and could not paste them
> into LibreOffice. I could paste them back into an email or to another
> calculator window. A minute or so later I could paste them into LibreOffice,
> no problem.
> 
> I have been trying to find out what could be locking it, but so far no luck.
> https://superuser.com/questions/770476/how-to-check-which-application-has-
> the-clipboard-hold
> 
> Are there any other tools that could help me track it down?

I have gone back to 6.4.6 which has much better pasting behaviour. Although pasting occasionally breaks, using the Reload option on a file solves it instantly.
Comment 10 QA Administrators 2020-10-20 04:20:31 UTC Comment hidden (obsolete)