https://bz.apache.org/ooo/show_bug.cgi?id=127907
--- Comment #10 from Marcus <[email protected]> --- Please make sure that the cells contain only numbers that can be sorted. If they contain additional characters then it's of course not possible: With a quick test I've found cells E1085, E1086, E1088, E1124. After deleting the space sorting was OK for me. I'm pretty sure that this is the root course for all your sorting problems. I don't know if you would exect this but it's also not possible to sort the following values together with the pure years or dates: August 2015 , 05.06.2015 , 1989 , 01/2000 , 2008? , 11/30/1993 ? , 81 or 82 Also some cells contain an apostroph (like in cell D11) at the beginning of the value - which is only visible in the edit mode of a cell. This is interpreated also as a non-number and is therefore not sortable. I hope this helps. -- You are receiving this mail because: You are the assignee for the issue.
