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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
