<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Improper SORTING on the date field for certain date formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=88769#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Improper SORTING on the date field for certain date formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=88769">bug 88769</a> from <a class="email" href="mailto:b.inhelder@bluewin.ch" title="Bruno <b.inhelder@bluewin.ch>"> Bruno</a> <pre>(In reply to krafczyk.matthew from <a href="show_bug.cgi?id=88769#c4">comment #4</a>) > This bug is still present on branch 5.4.0.0.alpha0+ on linux. > > To reproduce, open a new Libreoffice Calc doc and enter the following table: > > A | B > ------------------------------ > 2017 31 Jan | A > 2017 10 Feb | B > 2017 20 Mar | C > 2017 01 Apr | D > > Select the 4 cells of column A, and navigate to the 'Format' menu and select > 'Cells...'. > > Then set the format to Date and enter the format 'YYYY D MMM' pressing the > check mark to add the format and set the format of those cells. > > Now select all the 8 cells between column A and B and select 'Data' and then > 'Sort...'. Then set 'Sort Key 1' to 'Column A' and select either Ascending > or Descending. > > You will find that the cells are sorted as if they were strings rather than > dates. Same on V5.4 Win with Date format dd.mm.yyyy. Doesn't sort like a date but just alphabetically.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>