[Libreoffice-bugs] [Bug 119524] New: Calc: SUM fails to give sum without any indication of the failure cause

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119524

            Bug ID: 119524
           Summary: Calc: SUM fails to give sum without any indication of
                    the failure cause
           Product: LibreOffice
           Version: 6.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kittykat3756 at gmail.com

Description:
The SUM function works on some rows in the document and not on others, I cannot
find the reason for it not working (row formatting is identical as far as I can
see and I've tried copy/pasting the formatting). There is no other indication
for why it may not be working that I can see.

In the end, I fixed it by copy/pasting the content of the working SUM cell in
the H column into one that was broken. When I tried to undo the copy/paste, it
still kept working after the change was undone.

Steps to Reproduce:
Not sure how I triggered the bug. I copy pasted the first row with the
calculation into all the subsequent rows and filled in the numbers for adding
up manually. First few rows add up correctly, but later ones do not. (See
screenshot.)

I have tried applying the formatting from the working rows to the broken rows
with no change.

Actual Results:
SUM of D31:G31 shown as £700.00 in H31 (see screenshot)

Expected Results:
SUM of D31:G31 shown as £858.10 in H31 (see screenshot)


Reproducible: Couldn't Reproduce


User Profile Reset: No



Additional Info:
Version: 6.0.6.2
Build ID: 6.0.6-1
CPU threads: 4; OS: Linux 4.17; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180827/364871cb/attachment.html>