[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 #13 from Jonny Grant <jg at jguk.org> ---
(In reply to Eike Rathke from comment #12)
> 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.

-- 
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/91c9151a/attachment.htm>