https://bugs.freedesktop.org/show_bug.cgi?id=87506
Bug ID: 87506
Summary: Inconsistency in how LibreOffice Calc
4.4.0BetaDevDaily handles real numbers internally.
Product: LibreOffice
Version: 4.4.0.0.beta1
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Found this responding to comment 3 on bug 87386. Where C13 contains the number
24.09, the comment says "MOD(C13,1)*100 = 8.999999999999999". In the daily
build of LibreOffice4.4Dev(en) downloaded on Dec 18, 2014, if C13 contains the
number (not text) 24.09 then =MOD(C13,1)*100 does return 8.99999999999999 but
displays it as 9 (regardless of cell width) and treats it as 9:
in cell A1 enter the number 24.09
in cell B1 enter =MOD(A1,1)*100 (9 is displayed)
in cell B2 enter =MOD(A1,1) (0.9 is displayed)
highlight and copy range B1:B2
move to cell C1
paste special text/numbers/date & time
in cell E1 enter the number 9
in cell E2 enter the number 0.09
in cell D1 enter =C1=$B1
copy cell D1 and paste it to cell D2 and to range F1:F2
in cell G1 enter =C1=E1
copy cell G1 and paste it to cell G2
Every cell in range F1:G2 displays TRUE, meaning that to LibreOffice Calc, 9 =
8.99999999999999 and 0.09 = 0.0899999999999999. This is not true, except for
most practical purposes. In Excel, all the cells in range F1:G2 will show
FALSE, which most people would expect. I do not know if this is causing bug
87386.
It is as if Excel and LibreOffice are displaying the same number of decimal
places in calculation results, but Excel is calculating to a larger number of
decimal places and adjusting what it displays and uses in subsequent
calculations to prevent problems due to the inherent inaccuracy of calculating
real numbers digitally.
I would be surprised if this problem depends on the OS version of LibreOffice
used.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
