[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 #26 from Jonny Grant <jg at jguk.org> ---
(In reply to Mike Kaganski from comment #23)
> (In reply to Jonny Grant from comment #21)
> > 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 comment #25)
> Created attachment 158160 [details]
> 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.
https://bugs.documentfoundation.org/show_bug.cgi?id=130728

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.

-- 
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/20200225/222cb927/attachment-0001.htm>