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"

You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

  calc: move cell does not update row sum

To manage notifications about this bug go to:

ubuntu-bugs mailing list

Reply via email to