Hello all.
Assuming cell contains data (numbers/a formula), and I want to copy and then Paste or Paste Special to end up with data in the new cell not an image of the original cell. Calc has recently (Jan / Feb 2018) stopped copying in the normal way. This behaviour follows a period (in 2017) when I’d sometimes have to restart Calc to restore normal copying, or fully re-boot PC then re-start Clac; before that Copy/Paste was just normal as it has been in Excel for years and years. Something in my Calc seems to be changed. I now use Windows 10, and I also work with a few spreadsheets on both Win 10 and Android (using Polaris Office free). Using Calc Version: 5.4.5.1 (x64) which reports itself as being up to date.
Many thanks
David
Make sure there’s not some sort of Clipboard “Manager” running that messes around with clipboard content and/or types.
Pls test if Menu/Help/Restart in Safe mode, can help.
The answer was, just as Eike Rathke (erAck) correctly suggested, to disable a clipboard manager I’d installed - ClipboardFusion, which I installed because I don’t know how to access recently deleted things in Windows 10 (unlike Android which allows access to the clipboard I believe).
Well done Eike, the right answer as soon as I asked the question ! Impressive. Please accept my apologies for not getting back to you sooner to say thanks.
For the record, Restarting in Safe Mode made no difference, a simple cut and paste of a single cell resulted in a text box of the cell’s contents being pasted.
Yeah those “Managers” should be called Clipboard Destroyers instead. What they usually do is store a copy in one of the possible formats a content is offered in. As dumb as they are that usually is raw text, but your’s seems to have chosen a bitmap image or some such, which is equally wrong of course. The worst (eg. your’s) don’t even forward the current original offers. In any case, ~none of them can handle the LibreOffice/Calc/Writer/… internal clipboard formats so ~all are doomed to fail.
Having the same issue. I can’t find any installed clipboard manager. Pop_OS! (Ubuntu 19.10).
Likewise. Also using LibreOffice 6.5.3.2 in Ubuntu 19.10, and had the same problem in previous versions.
Repeating the copy and paste gets the expected result.
I also find that I usually have to copy twice to get a cell into the clipboard.
There are just so many broken bits of LibreOffice Calc which never get fixed that I’ve given up filing bug reports.
Note that clipboard managers breaking copy&paste is not a problem of LibreOffice. For the specific case of recent Ubuntu (and maybe other recent distributions using GNOME on X with the Mutter composer) see that answer.
Thank you for the answer. Yes, I installed Clipboard Fusion about a week ago and Libre Office Calc started playing up almost straight away when I copied my sheet for October forward for November.
Just for the record, Windows 10 now has a built-in clipboard manager. It needs to be activated in Settings but after that it can be accessed by Win+V.
Let’s hope it isn’t as dumb as so many others.
I have been trying to test it in real life but I just keep forgetting to access it; it doesn’t really fit with my workflow. On the few occasions I tried it there weren’t any extra abnormalities - so far.