[Libreoffice-bugs] [Bug 138652] New: Sorting in Calc by Date

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138652
           Summary: Sorting in Calc by Date
           Product: LibreOffice
           Version: 6.3 all versions
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: saltyla1 at gmail.com

Description:
Sorting by Date will not sort properly, and results are only partly sorted. I
tried all that I could think of.   Date format  10/2/20 .  Sorted as; 10/19/20
, 10/2/20 , 10/20/20 .

Steps to Reproduce:
1.Use date with format 10/1/20 Through  10/31/20 
2.Insert dates in single column in random order
3.Sort with column in proper date format, Ascending.

Actual Results:
Results abbreviated : 10/1, 10/10, 10/11 - 10/19, 10/2, 10/20, 10/21 - 10/29,
10/3, 10/30, 10/31, 10/4, 10/5, 10/6, etc.

Expected Results:

10/1/20 ,10/2,10/3,10/4,10/5,10/6,10/7,10/8,10/9, 10/10, 10/11 - 10/19, 10/20,
10/21 - 10/29, 10/30, 10/31, etc.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
LibreOffice  7.0.3.1 (x64)

[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information ]
OS: Windows 10
OS is 64bit: yes

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 16; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

-- 
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/20201204/3de68316/attachment-0001.htm>