<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - ImpSvNumberInputScan::StringToDouble may produce inaccurate result" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130725#c20">Comment # 20</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - ImpSvNumberInputScan::StringToDouble may produce inaccurate result" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130725">bug 130725</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to Jonny Grant from <a href="show_bug.cgi?id=130725#c19">comment #19</a>) > 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 <a href="show_bug.cgi?id=130725#c0">comment 0</a>, 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] <a href="https://www.binaryconvert.com/result_double.html?decimal=048046048052050">https://www.binaryconvert.com/result_double.html?decimal=048046048052050</a> [2] <a href="https://wiki.documentfoundation.org/Faq/Calc/Accuracy">https://wiki.documentfoundation.org/Faq/Calc/Accuracy</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>