<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>