https://bugs.documentfoundation.org/show_bug.cgi?id=172481
--- Comment #11 from ady <[email protected]> --- (In reply to Liliia from comment #9) > Created attachment 207475 [details] > List of Dates for sorting In attachment 207475, you present 3 cells with values, in the range D1:D3. Cells D2 and D3 are parsed as dates, in the format MM/DD/YYYY, but cell D1 is not a date, despite having the same Format code. One way you could test the real kind of content of these cells is to use the Value Highlighting feature; another would be to use the N() function. In cell E1, use the formula: =N(D1) and similarly on cells E2 and E3 use "=N(D2)" and "=N(D3)" respectively. You should see the internal serial number for dates, but zero for text. Please use a forum such as <https://ask.libreoffice.org> before posting / opening a bug report, so other users can either confirm that there is indeed a bug, or help you solve / workaround possible problems. This is still not a bug. -- You are receiving this mail because: You are the assignee for the bug.
