Public bug reported:
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)
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug xenial
** Attachment added: "test case"
https://bugs.launchpad.net/bugs/1704740/+attachment/4916021/+files/move_cell_does_not_update_sum_v6.ods
--
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 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/ubuntu/+source/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
