Ask Your Question

How to make sure Calc copies cell data (Using Ctrl C) instead of copying an image of the cell ?

asked 2018-04-02 16:51:59 +0100

Daviddecw gravatar image

updated 2018-04-04 14:08:50 +0100

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: (x64) which reports itself as being up to date. Many thanks David

edit retag flag offensive close merge delete



Make sure there's not some sort of Clipboard "Manager" running that messes around with clipboard content and/or types.

erAck gravatar imageerAck ( 2018-04-04 16:01:34 +0100 )edit

Pls test if Menu/Help/Restart in Safe mode, can help.

m.a.riosv gravatar imagem.a.riosv ( 2018-04-04 23:47:52 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-07 15:12:05 +0100

Daviddecw gravatar image

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.

edit flag offensive delete link more


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.

erAck gravatar imageerAck ( 2018-06-07 15:56:07 +0100 )edit

Having the same issue. I can't find any installed clipboard manager. Pop_OS! (Ubuntu 19.10).

lordbah gravatar imagelordbah ( 2020-03-12 16:45:48 +0100 )edit

Likewise. Also using LibreOffice 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.

jrussell88 gravatar imagejrussell88 ( 2020-05-11 12:50:57 +0100 )edit

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.

erAck gravatar imageerAck ( 2020-05-11 15:20:50 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-02 16:51:59 +0100

Seen: 379 times

Last updated: Jun 07 '18