https://bugs.documentfoundation.org/show_bug.cgi?id=140695
Peter S Anderson <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from Peter S Anderson <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
