[Libreoffice-bugs] [Bug 133893] New: : sum function omits one value from list, add two values includes it

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133893
           Summary: : sum function omits one value from list, add two
                    values includes it
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mark at markfielden.me.uk

Created attachment 161873
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161873&action=edit
zip file containing .ods and .odt files referred to, plus image

I copied a list of five numerical values from a table in a .odt file.
The .odt file itself had been converted from a .docx file a few iterations ago.
Used =SUM(E29:E34) to add up the column.
The calculated total seemed too small.
Added the cumulative column to check it.
values  cumulative
15.14   15.14
19.42   34.56
        34.56
15.2    49.76
25.25   75.01
25.00   100.01
75.01   

Both files attached.
Also attached an image in case you can't reproduce the problem.

-- 
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/20200611/51a960d1/attachment.htm>