[Libreoffice-bugs] [Bug 109189] Internal SUM calculation of over 6 negative decimal values results in rounding error

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jacques Guilleron <guilleron29 at aol.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
                 CC|                            |guilleron29 at aol.com
     Ever confirmed|0                           |1

--- Comment #2 from Jacques Guilleron <guilleron29 at aol.com> ---
Hi C.Drewke,

This sum function in Status bar follows the cells format. By default, there is
no value for decimal places with ths Standard format, you get so the greatest
precision and no rounding.
If I enter =SUM(A1:A6) into A7, I get here 0, a rounded value, with the
Standard format.

To make some differences, Excel give also a rounded value 0, when A1:A6 is
selected and -7,10543E-15 precision only when Sum in A7 is selected too, still
with the Standard format.
With any decimal place number, Excel give always a simple 0 for A1:A6 selection
and follows the cell format when A7 is selected and formatted.

Do you expect the same behavior?

-- 
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/20170724/6057af55/attachment-0001.html>