[Libreoffice-bugs] [Bug 130725] ImpSvNumberInputScan::StringToDouble may produce inaccurate result

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #20 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Jonny Grant from comment #19)
> What do you think of the screenshot.

As I mentioned in the AskLibO discussion, when a person claims some level of
expertise, the expectations of the other side of the discussion change. I hoped
that being "a comp sci", you could understand the essence of the problem here,
where LibreOffice incorrectly converts entered text "0.042" into corresponding
closest IEEE 754 double precision number. LibreOffice has a bug here, which is
identified, and a solution is needed, and is being developed. This has been
described here, right in comment 0, so hopefully you could understand that.
Taking that into account, if we fix this bug, i.e. will convert "0.042" into
the *closest* binary representation (which is still not exactly equal to 0.042:
see [1]), then LibreOffice would automatically start showing the *same* result
in this example.

Which doesn't mean that it would also show expected results everywhere: e.g.,
see the example I put into the FAQ [2]. So here comes *your* PoV (which *we*
understand clearly): that either Calc must calculate that precisely (which
requires software calculations with infinite precision, and is clear WONTFIX),
or that it at least should not show that to user automatically (unless
explicitly told so), i.e. to limit automatic number format precision - which is
what I recommended you to file separately.

I *hope* that now you realize that we do understand you, and it's time for you
to make an effort to understand *us*.

[1] https://www.binaryconvert.com/result_double.html?decimal=048046048052050
[2] https://wiki.documentfoundation.org/Faq/Calc/Accuracy

-- 
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/20200224/18891724/attachment.htm>