<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 - Not Sorting Dates Correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131377">131377</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Not Sorting Dates Correctly
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>c319chris@aol.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Windows 10: Version: 6.4.1.2 (x64)
In Calc, when pasting dates from imported .csv file, cell format changes from
previously-chosen "date" format to "text" format. Dates then acquire a leading
apostrophe: '03/11/2020, making it impossible to change the text formatting
without manually editing the cells to remove the leading apostrophe. Converting
dates to text strings can cause dates to be sorted incorrectly even though the
dates are displayed correctly. This happens even if cells have been previously
formatted as "date" format.
Steps to Reproduce:
1. Import list of dates from .csv file formatted as 03/10/2020
2. Note that dates now have a leading apostrophe.
3. Choose Data->Sort Ascending or Data->Sort Descending
Actual Results:
See above.
Expected Results:
Dates should retain date format and be correctly sorted.
Reproducible: Always
User Profile Reset: No
Additional Info:
Dates should retain date format and be correctly sorted.</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>