Ask Your Question
0

Why does LibreOffice calc copy text and paste pictures randomly? [closed]

asked 2020-01-13 08:24:37 +0100

Avid User gravatar image

Recently upgraded to Version: 6.3.3.2 when moving to Ubuntu 19.04

Like the version. But I'm having trouble using copy paste in Calc. It appears I've found a bug in the wild.

When I copy cells using CTRL+C and paste with CTRL+V: Most of the time the first time I copy and paste information it gets pasted as a picture of the cells I copied

After undo-ing everything, I copy again following exactly the same selection and copy method. But this time the contents of the cells are copied and pasted.

I've tried using the right-click menu as an alternative with the same results.

Please advise if there is a less frustrating workaround for this bug.

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by erAck
close date 2020-01-13 13:41:11.481127

Comments

Why does LibreOffice calc copy text and paste pictures randomly

This statement is contradictory in itself. If Calc copies text, then nothing can paste a picture (an images). You just assume to copy text but you don't. That's why there is a Paste Special (CTRL+SHIFT+V) functionality. In addition you need to take into account that there might be a clipboard manager in place and then LibreOffice got no control how this piece of software handles all these copied entities.

Opaque gravatar imageOpaque ( 2020-01-13 10:39:02 +0100 )edit

@Opaque I don't make the software I just use it. And I've been using spreadsheets for years. "This statement is contradictory in itself." -- Exactly the software works contrary to its design - hence I called it a bug.

I've added more detail below to make it clear what steps I follow...

My task involves moving several rows of information from the main sheet to another sheet.

Here are the exact steps I followed: 1. I have imported CSV data and saved it as ODS format. 2. I select all the cells in a row with the mouse 3. I press CTRL + c (and have also tried right click + copy | and also tried cutting which produces the same results when I paste) 4.I want to move the row to another sheet 5.I create the sheet for the first row I want to paste 6. I press CTRL ...(more)

Avid User gravatar imageAvid User ( 2020-01-13 12:25:39 +0100 )edit

I don't make it either - I just use it and I never faced what you describe in Copy&Paste from one Calc sheet to another Calc sheet (same format !) and that's why I'd point to Ubuntu's clipboard manager as a first source of the problem (I may be complete wrong - thus your detailed description is important to problem analysis). In that sense it is not yet clear which part of the process is causing the problem and it's just too early to state LibreOffice is causing a / the bug and works contrary to its design. And to make it clear: CTRL+C doesn't copy text but cells including all of its formatting and properties. It's a misconception, if you assume the design would be CTRL+C to copy text only.

Which desktop manager are you using (GNOME, Mate, Xfce, KDE ...)?

Opaque gravatar imageOpaque ( 2020-01-13 12:45:50 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-01-13 13:41:02 +0100

erAck gravatar image

This is a bug in the recent Mutter clipboard manager in Ubuntu 19.04, see comments in https://ask.libreoffice.org/en/questi... for details.

edit flag offensive delete link more

Comments

Thanks I'm glad the bug has been identified.

Avid User gravatar imageAvid User ( 2020-01-13 16:14:57 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2020-01-13 08:24:37 +0100

Seen: 27 times

Last updated: Jan 13