Launchpad has imported 3 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=121568.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2018-11-20T23:41:03+00:00 SatPhil wrote: Description: See attached test case. Sum two rows: A1 + B1 = C1; A2 + B2 = C2 where B1 is blank. Cut B2 and paste into B1. Result C2 is decremented correctly by old B2 value; but result C1 is NOT incremented by new B1 value. Formula of C1 remains correct =SUM($Sheet1.A1:B1) as is C2's formula but C1 result is wrong. Saving file, close and re-open does not fix incorrect C1 result. Undo undo to return to initial state results in C2 now having incorrect result. Bug occurs whether drag and drop or control-x/control-v used. This is a data integrity issue as the wrong answer is being displayed. Steps to Reproduce: 1. Sum two rows: A1 + B1 = C1; A2 + B2 = C2 where B1 is blank. 2. Cut B2 and paste into B1. Result C2 is decremented correctly by old B2 value; but result C1 is NOT incremented by new B1 value. 3. Formula of C1 remains correct =SUM($Sheet1.A1:B1) as is C2's formula but C1 result is wrong. 4. Saving file, close and re-open does not fix incorrect C1 result. 5. Undo undo to return to initial state results in C2 now having incorrect result. 6. Bug occurs whether drag and drop or control-x/control-v used. Actual Results: C1 not incremented by new B1 value; undo does not return to initial state Expected Results: C1 incremented by new B1 value; undo does return to initial state Reproducible: Always User Profile Reset: No Additional Info: Reproduced reliably by olivier.til...@canonical.com on Ubuntu 16.04 and 19.04 (libreoffice 6.1.3.2). He can also reproduce the issue with the upstream build of libreoffice (6.1.3.2) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/3 ------------------------------------------------------------------------ On 2018-11-20T23:42:51+00:00 SatPhil wrote: Created attachment 146856 "Before" state of test case. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/4 ------------------------------------------------------------------------ On 2018-11-21T13:45:06+00:00 Xiscofauli wrote: Regression introduced by https://cgit.freedesktop.org/libreoffice/core/commit/?id=5ef856e975d7c0396984d588a43fd1a7c7085c55, which is the same as in bug 121043. Closing as RESOLVED DUPLICATED *** This bug has been marked as a duplicate of bug 121043 *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/6 ** Changed in: df-libreoffice Status: Unknown => Invalid ** Changed in: df-libreoffice Importance: Unknown => Medium -- 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/1704740 Title: calc: move cell does not update row sum Status in LibreOffice: Invalid Status in libreoffice package in Ubuntu: New Bug description: See attached test case. Sum two rows: A1 + B1 = C1; A2 + B2 = C2 where B1 is blank. Cut B2 and paste into B1. Result C2 is decremented correctly by old B2 value; but result C1 is NOT incremented by new B1 value. Formula of C1 remains correct =SUM($Sheet1.A1:B1) as is C2's formula but C1 result is wrong. Saving file, close and re-open does not fix incorrect C1 result. Undo undo to return to initial state results in C2 now having incorrect result. Bug occurs whether drag and drop or control-x/control-v used. This is a data integrity issue as the wrong answer is being displayed. ProblemType: Bug DistroRelease: Ubuntu 16.04 Package: libreoffice-calc 1:5.1.6~rc2-0ubuntu1~xenial2 ProcVersionSignature: Ubuntu 4.4.0-83.106-generic 4.4.70 Uname: Linux 4.4.0-83-generic x86_64 NonfreeKernelModules: wl ApportVersion: 2.20.1-0ubuntu2.9 Architecture: amd64 CurrentDesktop: Unity Date: Mon Jul 17 17:33:42 2017 EcryptfsInUse: Yes InstallationDate: Installed on 2016-05-08 (435 days ago) InstallationMedia: Ubuntu 16.04 LTS "Xenial Xerus" - Release amd64 (20160420.1) SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1704740/+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
