https://bugs.documentfoundation.org/show_bug.cgi?id=165982
--- Comment #2 from [email protected] --- Well, the process was not as automatic as you think. The csv converters: integrated in Libreoffice Calc / Excel. in LibreOffice: UTF-8 didn't work because of the Umlaute (ä, ö, ü). So I had to change to "automatic", which was then put to "west european" (ISO-8859-1). All my programs are on the same computer (Windows 11, language: Swiss-German with the respective date-time templates). All columns were "standard", the two date columns I changed to Date (TMJ, nothing else to choose from like TT.MM.YYYY). After converting the csv to a format which Calc could work with, I saw that the two date columns were nontheless text entries, with a leading apostroph. In order to be able to sort by date I would have had to change every entry and delete teh leading apostroph. Which is no fun when you have large tables. In contrast: Excel would recognise the date columns and would therefore be able to sort them. So it's not a rant, but a complaint. -- You are receiving this mail because: You are the assignee for the bug.
