<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#c13">Comment # 13</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 Eike Rathke from <a href="show_bug.cgi?id=130725#c12">comment #12</a>) > Oh we love bug comments that just chime in to tell a second time that > something is wrong. Maybe we should limit Calc's precision to 8 decimal > digits then. I guess I still love bug comments that chime in with a clear understanding of the issue. Would you have this argument with an accountant? An auditor? An actuary? The difficulty you face is, like me you're a comp sci, or software engineering graduate, or post-grad, so for such IT people it makes sense... It's a shame, as we're designing software for users, not comp sci grads. It's simply that it doesn't make logical sense for any users of your product, a spreadsheet, it's not meant to be like Fortran, it's meant to be for users! Casio or any other accountants software or calculator does not display to 8 decimal digits a number like 0.0001000 There are many ways this bug could be fixed, ie this cell A3 that is empty, on a blank new sheet does not have any formatting, so simply format it to display the result of the sum as 0.0001 Speaking frankly, I give up. Google Calc doesn't suffer this bug.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>