https://bugs.freedesktop.org/show_bug.cgi?id=50299
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|NOTABUG |--- Summary|MOD shows not existing |MOD shows not existing, |small remainder with |inconsistent, small |calculated Dividend |remainder with calculated | |Dividend Ever confirmed|0 |1 --- Comment #20 from [email protected] --- in cell A6 enter 0.3 in cell B6 enter =MOD(A6*100, 10) cell B6 displays 3.5527136788005E-015 in cell A6 enter =3/10 cell B6 displays 0 So letting the hardware create the 0.3 instead of using LO Calc's stored 0.3 gives the correct answer. That doesn't prove it's not a hardware bug, but it proves it is or is also a software bug, and I have confirmed that it exists in LO 4.4.0 Beta Dev Daily I installed 2014-12-18 AND in Excel 2003, but not as bad. More on that when I reopen 87506 with a spreadsheet example showing just how bad the LO Calc MOD() function can be. Same result using 0.6 vs 6/10 "We can't fix it or don't think it's worth fixing, so mention it in the documentation and it's resolved" does not resolve the problem. Explaining it to the average person wouldn't help them (if they ever happen to read it - have you read, understood and remembered all the documentation of every piece of software you use?). They would understand "if you use the MOD() function, the answer might be right and it might not be, so you'd better check every use of the MOD() function manually". It means "don't use MOD(), it's not reliable". The correct resolution would be to remove the MOD() function from LO Calc until it has been fixed. -- 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
