<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Not Sorting Dates Correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131377#c13">Comment # 13</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Not Sorting Dates Correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131377">bug 131377</a>
from <span class="vcard"><a class="email" href="mailto:c319chris@aol.com" title="c319chris@aol.com">c319chris@aol.com</a>
</span></b>
<pre>Follow these steps:
File -> New -> Spreadsheet to make new destination spreadsheet.
Double click on .csv file to open it. Click "OK" on text import window.
Copy and paste cells into new spreadsheet, including "Date" column.
Select column A.
Click on Format -> cells. Note that column is formatted as "Number".
Select "Date" and choose any date format.
Program inserts apostrophes ahead of all date values. See formula bar to see
this as the apostrophe is not visible in cells. Cells have now been reformatted
as text due to leading apostrophe ahead of date value.
Selecting "Format -> Cells", the cells are formatted as "Date" but are actually
text due to apostrophe as first character. As text the dates cannot be
correctly sorted.
Note also that selected date format is not applied when cell values are
converted to text. Selecting "Friday, December 31, 1999" has no effect. Cells
are retaining original date format. Remember, cells were originally formatted
as "Number", not "Text".
Reformatting cells as "Number" does not remove apostrophes, leaving cells as
Text. Apostrophes must be removed manually, cell by cell.
The crux of the problem is that cells are being reformatted as text, not date.</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>