[Libreoffice-bugs] [Bug 139440] New: Calc 'Sort Ascending' does not properly sort when the field is date by mm/dd/yyyy

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139440

            Bug ID: 139440
           Summary: Calc 'Sort Ascending' does not properly sort when the
                    field is date by mm/dd/yyyy
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: john.oliver.3 at gmail.com

Description:
A csv file when opened in LibreOffice Calc did not properly sort ascending.
Specifically, the target column with header "Date" and values as mm/dd/yyyy
sorted as 01/01/2021, ... 01/05/2021, 03/01/2020, 03/02/2020 ... 12/31/2020.
The proper sorting should be 03/01/2020, 03/02/2020 ... 12/31/2020, 01/01/2021,
... 01/05/2021. That is, 2021 is being placed before 2020.
Thank you. 

Steps to Reproduce:
1.Open attached Calc file: Test_Sort.csv
2.Choose 'Data'-> 'Sort Ascending' on "Date column" 


Actual Results:
Dates with year 2021 are ordered before dates with year 2020

Expected Results:
Dates with year 2020 should precede dates with year 2020 as referenced to
increasing row number.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210106/4563bf44/attachment.htm>