https://bugs.documentfoundation.org/show_bug.cgi?id=145070
--- Comment #2 from Mike Kaganski <[email protected]> --- There's no conflict here. You are comparing strings, not numbers; they are compared lexicographically. When you compare string "10.5" to string "10.2", the latter is lexicographically before the former (its all but last characters are same, and last character in the latter is alphabetically before the one in the former). When you compare "abcd" to "abca", the latter is lexicographically before the former, for the same reason. When comparing "10.5" to "9.7", the latter is lexicographically after the former: they start from different characters, and that character defined the order. When you compare "abcd" to "xyz", the latter is lexicographically after the former, for the same reason. You need to use something like VALUE(LEFT(A1,4)) Closing NOTABUG. -- You are receiving this mail because: You are the assignee for the bug.
