Calc formula not appearing in clipboard or pasting into another sheet

Having searched around I have only found answers to this which relate to systems running Wayland. As I’m using x11 I am unable to discover why Ctrl-C (or Edit/Copy) followed by Shift-Ctrl-V (or Edit/Paste Special) only copies and pastes the result and not the formula from one Calc sheet to another.

Anyone got any insights?

(I’m using LibreOffice 6.3 on Ubuntu 18.04 LTS.)

After clicking on the cell in question, try highlighting and copying the formula from the Input Line (above the spreadsheet).

Hi ve3oat

Thanks for taking the time to reply.

Yes, your suggestion would and does work fine. However, Ctrl-c should (and previously has) copied the formula, not just the result.

I’m still hoping that someone has found out the root cause of this issue and can enlighten me. :slight_smile:


The problem has gone away, but I don’t know why!

Here’s what I did:

1 - Install Gnome desktop (I already had KDE) thus:

$ sudo tasksel install ubuntu-desktop

2 - Logout, and login with Gnome

3 - Check copy and paste – it worked fine, all formats preserved

4 - Reboot (there were updates which demanded I do so)

5 - Login with Plasma (KDE)

Now copy and paste in KDE also work fine, all formats preserved.

This seems - for now at least - to have fixed the clipboard issue. I hope it doesn’t return. Perhaps this information will be of use to someone else, one day, too!


The problem came back. I logged out of KDE, and logged in again. The problem had vanished. Clearly re-starting the KDE session fixed the fault, for now at least. I wonder how long it will stay fixed this time…


The problem came back again. But this time I noted it appeared after starting KRDC remote desktop connection client. So I did some testing. Now, many tests later, and a whole day, the problem seems to have stayed away. My solution was to uninstall KRDC remote desktop connection client, and use Remmina remote desktop client.

Might be some clipboard destroyer (aka “manager”) gets in the way, most of them are too dumb and pull just the text/plain type (or maybe some html or image formats as well) from the formats offered by the application, effectively ignoring everything else so the pasting application doesn’t see the other formats, i.e. here the Calc internal clipboard data.

If it works in a fresh KDE session that might be an indicator as then for the first paste the clipboard destroyer might not be involved yet and only gets in the way if multiple clipboard actions are stacked.

Hi erAck
See my “Further edit”. Seems KRDC remote desktop connection client is breaking clipboard.

Thank you for providing the solution to your problem!