https://bugs.documentfoundation.org/show_bug.cgi?id=145499
--- Comment #5 from Mike Kaganski <[email protected]> --- (In reply to Colin from comment #4) > Now I'm really confused; Does the formula you prescribed fix the error for > me or just prove the error exists It is to show that the numbers are different, so for the latter. > AND demonstrate that once again I've > learned two new things today. > Rounding the preceding values to try to eliminate the .000000000000001 > anomaly doesn't solve the problem It does. E.g., in the example that I suggested, if you round the formula in K1755 like '=ROUND(IF(G1755>0;G1755-I1755;"");1)', the double '73.6' entry in the autofilter list will disappear. As to the bug: note another manifestation of the wrong behavior, when selecting *both* '73.6' entries, then opening the filter list again, shows only *one* of these entries selected. -- You are receiving this mail because: You are the assignee for the bug.
