[Libreoffice-bugs] [Bug 116104] New: trivial sum() bad value

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116104
           Summary: trivial sum() bad value
           Product: LibreOffice
           Version: 5.1 all versions
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: fabrizio at bzimage.it

Created attachment 140238
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140238&action=edit
screenshot of the bug, libreoffice info + bugged .ods

Very strange bug: sum() seems to not to work in a trivial usage.

All info in attached files. 

cells in red show bad sum() value while green cell shows right value.
yellow cells has formula inside, while orange cells dont.
However only the white column show the correct sum() value (green) at the end.

See attached png what i see and libreoffice details.

The correct sum is 3793.58 (nor -46664.52 or 11493.58)

-- 
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/20180301/71c854ef/attachment.html>