Discussion:
[Bug 1678622] [NEW] Libreoffice copy paste doesn't copy calculations
(too old to reply)
Cliff Carson
2017-04-02 14:19:17 UTC
Permalink
Public bug reported:

When doing a copy/paste of rows only the text information is copied (a
"Text Import" dialog box is displayed which normally wasn't before). If
the copy/paste operation is repeated than the text and calculations are
copied. In fact if the copy (ctl-c) is hit twice and then the paste
(ctl-v) the operation works correctly. Using the Copy/Paste icons shows
the same incorrect behavior.

ii libreoffice-calc 1:5.3.1-0ubunt amd64 office
productivity suite -- spreadsheet

ProblemType: Bug
DistroRelease: Ubuntu 17.04
Package: libreoffice-calc 1:5.3.1-0ubuntu2
ProcVersionSignature: Ubuntu 4.10.0-14.16-generic 4.10.3
Uname: Linux 4.10.0-14-generic x86_64
ApportVersion: 2.20.4-0ubuntu2
Architecture: amd64
CurrentDesktop: GNOME
Date: Sun Apr 2 10:05:34 2017
InstallationDate: Installed on 2017-02-13 (47 days ago)
InstallationMedia: Ubuntu-GNOME 17.04 "Zesty Zapus" - Alpha amd64 (20170211)
ProcEnviron:
TERM=xterm-256color
PATH=(custom, no user)
XDG_RUNTIME_DIR=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New


** Tags: amd64 apport-bug zesty
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
dino99
2017-04-02 14:47:22 UTC
Permalink
hi Cliff

i have the same installation as yours, and does not confirm that
problem; you might check how are set the libreoffice calc options.

the 'hit twice' can also be due to some dirty contacts from the keyboard
(if used); that seems a bit strange and looks more a mechanical problem
than a soft one at first glance.

** Changed in: libreoffice (Ubuntu)
Status: New => Incomplete
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-02 18:37:06 UTC
Permalink
Interesting. Tried again on my laptop to do a copy/paste and had the
failure. Marked the cells to be copied and hit ctl-c. Moved to open
area and hit ctl-v and this opened a "text import" box (which is not
normal) and after hitting OK the cells where copied but did not include
any calcs. Have the same Ubuntu/Libreoffice level and spreadsheets on a
desktop and when I tried to reproduce this problem I could not. Back to
the laptop. Tried and was able to reproduce the problem every time and
then rebooted to Ubuntu 16.10. The spreadsheet file is the same but
under 16.10 I could not reproduce on the laptop. Rebooted to 17.04 and
tried the same steps that failed every time before but could not
reproduce the problem. Don't feel this is a hardware problem since it
was so consistent under Libreoffice (tried many times just to understand
what was going on) but don't see problems under other problems under
other applications. Also as I said using the copy/paste icons resulted
in the same failure as the using the ctl-c/ctl-v. Right now do not have
a problem but will continue to try to reproduce.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-03 20:42:02 UTC
Permalink
Tried many times to reproduce this problem since my last append and it
did come back. There are three methods to copy/paste. Using
ctl-c/ctl-v, the copy/paste icons, and the edit pull-down. Each method
results in the same failure. I mark a number of cells to be copied, do
the copy, move to a target cell, and then paste. Every time when this
is failing I get an "Import Text" menu box. Entering OK to this box
copies only the text information not any calculations. This box should
not come up. If I mark cells, copy, copy (using any of the three
methods), then paste the operation works correctly (no "Import Text" box
displayed).

I don't know what to try next to document this failure. Any
suggestions?
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-03 23:20:15 UTC
Permalink
Simplified failure description...
Mark a single cell that has data and formula. Hit ctl-c once, move to an open cell and hit ctl-v. When this is failing the data in the marked cell is copied to the new cell but not the formula.
Unmark the cell by marking any other cell and then mark the formula cell again. Hit ctl-c twice, move to an open cell and hit ctl-v. The formula is copied, adjusted and cell content recalculated.
While this was failing tried to copy formula to multiple cells...
Marked the formula cell, ctl-c once, marked 3 cells one column over, ctl-v. The data in the formula cell was copied to the first target cell and the other cells left blank. Formula not copied.
Mark the formula cell, ctl-c twice, mark 3 cells one column over, ctl-v. Operation worked as expected. Formulas copied, adjusted, and cells recalculated.

Had to reboot this laptop and the failure is gone again. I was failing
every time and on all the spreadsheets I tried.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-04 20:57:30 UTC
Permalink
See this failure every day at different times after boot. When it
starts to fail every cell copy/paste will fail. Just because I don't
know what to do next and I know there is a memory leak problem with
gnome-shell I got into the failing condition and issued "gnome-shell
--replace" and the next attempted at copy/paste worked although the
failure comes back the next copy/paste. This may explain why when this
is failing a reboot works.

Unless someone has something any suggestions to add I'm going back to
16.10 gnome.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-05 18:51:47 UTC
Permalink
gnome-shell has nothing to do with this problem. Replaced the Ubuntu
Gnome system with Ubuntu Unity and continue to have the problem in the
spreadsheet, in fact fails more consistently. Could almost agree that
this is a hardware problem if there were not so many ways to do the
copy/paste using different keys/mouse/menu but they all fail the same
way.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-06 13:37:56 UTC
Permalink
It appears that there is a problem using Keepassx in Zesty. I have been
using Keepassx across many release of Ubuntu and not seen this problem.
I can reproduce the problem above by just having the Keepassx window
open (all Keepassx setting are at default). This now makes sense for the
problem being intermittent (only fails when I've started Keepassx) and
the fact that Keepassx is using the copy/paste function to pass on
information. Not sure what to do with this bug report since this is
clearly not a Libreoffice problem, see problems in Nautilus doing
copy/paste operations also.

Successfully reproduce this problem on a Ubuntu-gnome 17.04 desktop.
Never saw this problem on the desktop but rarely ever run Keepassx on
it.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
dino99
2017-04-06 14:01:55 UTC
Permalink
Ah, i've never used Keepassx, so it might explain why i've not seen this
issue.

You can change this title report to something like "Keepassx disturbing
apps's copy/past (nautilus, LO, ...)
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keepass2/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
dino99
2017-04-06 14:02:49 UTC
Permalink
and change the affected package to 'keepassx' instead of LO
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Libreoffice copy paste doesn't copy calculations

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keepass2/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Cliff Carson
2017-04-06 14:08:52 UTC
Permalink
That should be Keepass2. Keepassx is the older version.

** Package changed: libreoffice (Ubuntu) => keepass2 (Ubuntu)

** Summary changed:

- Libreoffice copy paste doesn't copy calculations
+ Keepass2 on Zesty causes copy/paste problem in other applications
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Keepass2 on Zesty causes copy/paste problem in other applications

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keepass2/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
dino99
2017-04-06 14:48:42 UTC
Permalink
** Changed in: keepass2 (Ubuntu)
Status: Incomplete => Confirmed
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Keepass2 on Zesty causes copy/paste problem in other applications

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keepass2/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
David Lechner
2017-04-06 15:15:26 UTC
Permalink
*** This bug is a duplicate of bug 1659159 ***
https://bugs.launchpad.net/bugs/1659159

** This bug has been marked a duplicate of bug 1659159
KeePass 2.35 is not nice to your clipboard
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Keepass2 on Zesty causes copy/paste problem in other applications

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keepass2/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
dino99
2017-04-06 15:09:59 UTC
Permalink
*** This bug is a duplicate of bug 1659159 ***
https://bugs.launchpad.net/bugs/1659159

Glancing a bit more about keepass2 known bugs: debian have some close to that one, and pointing to 'mono' (keepass2 depends). Upstream also has a similar report (comments with details/workarounds)
https://sourceforge.net/p/keepass/bugs/1530/
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1678622

Title:
Keepass2 on Zesty causes copy/paste problem in other applications

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keepass2/+bug/1678622/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-***@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Loading...