[Libreoffice-bugs] [Bug 116918] Sum Total ignoring changes in client cells if they are formatted to hide decimals.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
So, as you show on your screenshot, the "Precision as shown" is indeed
selected. Thus, Calc uses numbers *as displayed in cells* for further
calculations. If you show a subtotal as a whole number, and then use it in
calculations of total, it's expected to behave as you describe. Unselect the
option to resolve the issue. In general, I'd not use it. If you need some
values to have limited precision, use ROUND.

Closing NOTABUG.

-- 
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/20180410/d62617f9/attachment.html>