<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Sorting in Calc by Date"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138652">138652</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Sorting in Calc by Date
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3 all versions
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>saltyla1@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>