[Libreoffice-bugs] [Bug 140695] calc: calculation: calc wrong results and less precise / accurate than ex$el?

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140695

Peter S Anderson <peter at pza.net.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |peter at pza.net.au

--- Comment #1 from Peter S Anderson <peter at pza.net.au> ---
I have reproduced this in 7.0.4.6 (x64) and found the same result. 
Enter 99999999.9999999 in one cell and  99999999.9999998 in another. Format to
show 7 decimal places to confirm. In another cell enter a formula to subtract
the two cells. The result is 0.0000000 (not 0.0000001) In fact it seems to be
exactly that.

I then did the same thing in Excel and initially got the same result. If I
entered the formula =(A1-A2)*1
The result changes to 0.0000000894. Very Interesting. Changing the formula
makes no difference in LibreOffice.

Will attach the Excel spreadsheet soon and do a bit more investigation.

-- 
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/20210305/37ad3f2b/attachment.htm>