When having characters and numbers in cell values, sorting leaves out the first cell in a column.
Created attachment 75239 [details]
the first cell (A1) is left out from sorting
That isn't a bug per se, it is caused by the options 'Field names in the first row' to be on by default.
Also, which version do you use? I cannot reproduce it with version 4.
I also cannot reproduce this problem with LO 220.127.116.11 on OS X.
@Gergő: Could you please re-try with the latest LO release and see if the problem persists. If that should be the case, please re-open and we'll further investigate.
Correct status is NotABug as explained in comment #2.
Was never confirmed -> regression keyword removed.
Best regards. JBF