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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1678622 Title: Libreoffice copy paste doesn't copy calculations Status in libreoffice package in Ubuntu: Incomplete Bug description: 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) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1678622/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp