https://bugs.documentfoundation.org/show_bug.cgi?id=109189
Jacques Guilleron <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEEDINFO
CC| |[email protected]
Ever confirmed|0 |1
--- Comment #2 from Jacques Guilleron <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
