https://bz.apache.org/ooo/show_bug.cgi?id=103166
--- Comment #12 from orcmid <[email protected]> --- (In reply to orcmid from comment #11) > Created attachment 84914 [details] > Three date formats that sort in the same sequence > > I will check your exact use of DD.MM.YYYY to see if that makes any > difference. In the third column, I used the explicit format DD.MM.YYYY and it all worked, even after resorting the 5 rows. Please check for how your DD.MM.YYYY cells are formatted as dates. I notice, on an en_US installation, if I enter 25.01.1939 without specifying that the cell is for a date format, the entry is treated as a text string (and left-justified in the cell). If I specify that format for the cells first, entries work just fine. So the problem some may experience is that DD.MM.YYYY in their locale is not automatically recognized as a date unless the cell format is specified first? -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
