[Libreoffice-bugs] [Bug 135103] Decimal precision fail in addition

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Javier <javier.debian.bb.ar at gmail.com> ---
(In reply to Michael Warner from comment #2)
> (In reply to Mike Kaganski from comment #1)
> > https://wiki.documentfoundation.org/Faq/Calc/Accuracy
> 
> I understand the limitations of IEEE754, and why this is a frequently asked
> question. That said, one could argue that it would be more user friendly if
> the formatting of a cell containing an equation (and the sum in the corner)
> defaulted to the number of decimal places shown to the minimum (or maximum)
> number of decimal places entered in any referenced cell containing a number.
> In the example provided, it just doesn't make sense to display a result to
> 14 places when at most 2 are provided.

That's one of the problems. If your boss see this, probably he doubt about
yours skills.

The other problem, every conditional must be formated before each calculation,
like

=IF( ROUND( (<cell with 31000.99> - <cell with 32000.12>;2) = ROUND( <cell with
-999.13>;2); "OK"; "FAIL" ) );

That's a very heavy issue, a lot of time, memory, CPU resource, bugs, etc.

-- 
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/20200725/756f2d53/attachment-0001.htm>