<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#c26">Comment # 26</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:jg@jguk.org" title="Jonny Grant <jg@jguk.org>"> Jonny Grant</a> <pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=130725#c23">comment #23</a>) > (In reply to Jonny Grant from <a href="show_bug.cgi?id=130725#c21">comment #21</a>) > > Could I ask, does your precision patch also resolve this test case? anyway, > > good to have a second test case. > > > > 30.9 > > 30.1 > > 0.799999999999997 > > No, this one will continue to give the same result as Google Sheets and MS > Excel (if set to show enough decimals). (In reply to Mike Kaganski from <a href="show_bug.cgi?id=130725#c25">comment #25</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158160" name="attach_158160" title="Google Sheets indeed does not have this bug, because this is not a bug">attachment 158160</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158160&action=edit" title="Google Sheets indeed does not have this bug, because this is not a bug">[details]</a> > Google Sheets indeed does not have this bug, because this is not a bug > > Please stop spamming, and learn reading (I wrote that you need to set it to > show enough digits); learn using the tool (discover for yourself how to > control shown precision); learn what precision is (equivalency of 0.50000... > and 0.49999... is useful here, studied in intermediate school); and finally, > learn using bug tracker - and stop abusing this issue with unrelated > messages. Thanks! I can lead a horse to water, but I can't make it drink. If you're going to force Google Docs to show the wrong number of decimal places - it's not surprising the result shown will be the double precision actual number stored in those bits Mike. Of course, we all know how to set the decimal places. You're right that there is a bug about displaying an illogical and wrong number of decimal places in LibreOffice Calc. <a class="bz_bug_link bz_status_REOPENED " title="REOPENED - Change Calc to display in appropriate precision" href="show_bug.cgi?id=130728">https://bugs.documentfoundation.org/show_bug.cgi?id=130728</a> Feels like this issue won't be fixed, and actually feels like I've been wasting my time here the whole time. I don't see the need to comment further at this stage.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>