https://bugs.documentfoundation.org/show_bug.cgi?id=162832
--- Comment #7 from [email protected] --- Created attachment 196305 --> https://bugs.documentfoundation.org/attachment.cgi?id=196305&action=edit file in spreadsheet .XLS format In making the XLS file I paid attention to the cell format. This showed that when I imported the CSV file, my version of Calc treated the dates and times as strings and so when I requested Sort, the Sort treated the data just as text. So in creating the XLS file, I first opened the CSV file, then set the cell format for the dates and times in the first two columns, and then I exported the results to make SortExample.xls. -- You are receiving this mail because: You are the assignee for the bug.
