https://bugs.freedesktop.org/show_bug.cgi?id=78447
--- Comment #5 from Dave Dixon <[email protected]> --- The fact that ROUND makes the problem go away doesn't address the fact that COUNTIF gets it wrong, and LARGE or SMALL gets it right. See my second attachment. correct COUNTIF number rank rank Error Difference 1.1676675775 18 18 1.0422684914 1.1409266053 19 19 0.0267409722 1.1193137951 20 21 X 0.0216128102 0.8905263441 21 21 0.2287874511 Where COUNTIF makes a mistake in ranking the numbers, the difference between the numbers is either 0.0216128102 or 0.2287874511. This is not a difference at the floating-point-precision level. It may be due to an error in the floating-point precision comparison that COUNTIF uses (and LARGE and SMALL do not). That makes it a bug, not an enhancement. -- 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
