Launchpad has imported 5 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=121043.
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-10-29T19:35:31+00:00 Aron Budea wrote: Created attachment 146149 Sample ODS - Open attached spreadsheet. - Cut A1. - Paste into A2 (overwrite existing data). => F2, which is the sum of A2:D2, isn't updated accordingly (should become 22 instead of 26). Observed using LO 6.2.0.0.alpha1+ (313392119522c21a6ecd14403d6f92c948149df7) & 4.4.0.3 / Ubuntu 18.04. No issue in LO 4.3.0.4. => regression Bibisected to the following commit using repo bibisect-44max. https://cgit.freedesktop.org/libreoffice/core/commit/?id=5ef856e975d7c0396984d588a43fd1a7c7085c55 author Kohei Yoshida <[email protected]> 2014-11-18 21:03:05 -0500 committer Kohei Yoshida <[email protected]> 2014-11-18 21:03:50 -0500 Use group area listeners during ODS import. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/2 ------------------------------------------------------------------------ On 2018-10-29T19:42:42+00:00 Aron Budea wrote: There are a couple of other, already fixed bugs starting with the same commit, eg. bug 86615. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/3 ------------------------------------------------------------------------ On 2018-10-29T21:46:48+00:00 Raal wrote: Confirm with Version: 6.2.0.0.alpha1+ Build ID: a50f845957fff66ca7f459da4878be4597e0bae3 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: x11; Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/4 ------------------------------------------------------------------------ On 2018-11-21T13:45:06+00:00 Xiscofauli wrote: *** Bug 121568 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/10 ------------------------------------------------------------------------ On 2018-11-21T13:47:01+00:00 Xiscofauli wrote: Hi Eike, I've just found this issue as being the same root cause of bug 121568, I thought you might be interested in this issue as it's affecting formulas... Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1704740/comments/11 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** 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: Confirmed 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 : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
