After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 751773 - Unable to copy/paste formula, formatting or ranges
Unable to copy/paste formula, formatting or ranges
Status: RESOLVED NOTABUG
Product: Gnumeric
Classification: Applications
Component: GUI
1.12.x
Other Linux
: Normal major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2015-07-01 09:38 UTC by Drew Ferguson
Modified: 2015-07-02 12:04 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Drew Ferguson 2015-07-01 09:38:01 UTC
Unable to copy/paste formula, formatting or ranges: only the result of the first cell is copied unformatted

Originating Cell will not highlight either: this used to be difficult a few versions ago but an update fixed it properly; now functionality is unusable

ArchLinux v1.2.20 under XFCE

Any clues how to focus in on what might be causing this? I assume its not the core product else others would have shouted
Comment 1 Drew Ferguson 2015-07-01 09:49:21 UTC
previously preference had been to "Prefer Clipboard over Primery selection"; switching this off and unable to Copy & Paste at all

Primary selection will not highlight/focus
Comment 2 Drew Ferguson 2015-07-01 11:12:18 UTC
Update to 1.2.22 and problem persists
Comment 3 Andreas J. Guelzow 2015-07-01 18:27:48 UTC
Please explain in detail what you are doing, e.g.: new empty Gnumeric file, enter ..., select..., etc.
And where what you observe differs from what you expect.
Comment 4 Morten Welinder 2015-07-01 19:21:09 UTC
Are you running anything that might aggressively take the clipboard
selection from Gnumeric?  Some crazy clipboard manager, for example.

Gnumeric offers the selection in many formats from xml to various image
formats and text.  If some other program takes the text and then offers
that back to Gnumeric as the selection, then you will get only text
copied.

Please try running with clipboard debugging on

    GNM_DEBUG=clipboard gnumeric

then do:

1. Enter "=A2+1" in A1
2. Select A1
3. Ctrl-C

If you see "Lost clipboard ownership." then something stole it.
Comment 5 Drew Ferguson 2015-07-02 10:13:37 UTC
Ooo thats helpful!
and pointed the finger at the guilty culprit:  xfce4-clipman-plugin

Entered this
 A1: 123
 A2: 123
 A3: =sum(A1..A2)
Highlight A3 & Ctrl-C
Move to B3 & Ctrl-V

With this plugin and "Prefer CLIPBOARD over PRIMARY" switched off I get this

Clipboard successfully claimed.
clipboard target=UTF8_STRING
** Message: clipboard text of 3 bytes
clipboard target=UTF8_STRING
** Message: clipboard text of 3 bytes
Lost clipboard ownership.

Kill the plugin and all is well

After Ctrl-C focus stays on A3 with the cell border as dashes and reports

Clipboard successfully claimed.

With "clipit" running, cut & paste works fine but

clipboard target=UTF8_STRING
** Message: clipboard text of 3 bytes

repeats continuously until hitting escape or losing focus on A3

With "clipman" running back to

Clipboard successfully claimed.
clipboard target=UTF8_STRING
** Message: clipboard text of 3 bytes
clipboard target=UTF8_STRING
** Message: clipboard text of 3 bytes
Lost clipboard ownership.

So the problem appears to be "clipman"; I shall banish it from my system
Comment 6 Drew Ferguson 2015-07-02 10:15:30 UTC
Morten: Thanks for the debugging tip!
Comment 7 Morten Welinder 2015-07-02 12:04:11 UTC
Thanks for reporting and, more importantly, more reporting back.

The debugging code exists because we have had this type of trouble before.
It's good to know the exact cause for future reference.