https://bugs.documentfoundation.org/show_bug.cgi?id=162832
--- Comment #17 from [email protected] --- Dear ady, I like your idea of closing this bug report; so go ahead and do that please according to your process. Since I suspect other users have or might make the same mistakes that I made, let me make the following SUMMARY Incorrect sort was due to not completing the "Text Import" parameters correctly. In the user's version of Calc, 6.4, "Detect special numbers" (<<< MY EMPHASIS added) must be checked to properly convert dates and times. Detail: Since "Detect special numbers" is not a self-explanatory expression, this is an easy mistake to make. The result is that the dates and times are read in to Calc as text strings. When the text string is in 12-hour time format and when there is "12" in the hour portion of the time (HH = 12), then an incorrect sort may result. LESSONS LEARNED: -- You are receiving this mail because: You are the assignee for the bug.
