Bug 68265 - Editing: spreadsheet - Sorting the lists do not sort by date correctly
Summary: Editing: spreadsheet - Sorting the lists do not sort by date correctly
Status: RESOLVED DUPLICATE of bug 68108
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.4.2 release
Hardware: Other macOS (All)
: medium blocker
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-19 09:25 UTC by Brittany D
Modified: 2013-08-22 20:21 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Screenshot of my spreadsheet when sorted by date (271.15 KB, image/png)
2013-08-19 09:25 UTC, Brittany D 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Brittany D 2013-08-19 09:25:15 UTC 
Created attachment 84240 [details]
Screenshot of my spreadsheet when sorted by date

When sorting by date a spreadsheet of order information such as order date, order ID, title, category, item number, and seller the date field (even when "formatted" as a Date) does not sort properly. The sorting is done by the first part of the date which for my settings is the Month as in M/D/YY and then it sorts by day then year. It should be sorting by Year then Month then Day.
Comment 1 Tomaz Vajngerl 2013-08-19 10:36:37 UTC 
That is because your date isn't detected by Calc as a date but as text and it sorts it like alphabetically like text. If you imported a CSV file then this is related to bug in [1].

Regards, Tomaž

[1]: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68108
Comment 2 Tomaz Vajngerl 2013-08-22 10:08:13 UTC 

*** This bug has been marked as a duplicate of bug 68108 ***
Comment 3 Brittany D 2013-08-22 11:03:42 UTC 
I see that this is now considered a duplicate though I don't see why. Even after saving the file as an .odf and resorting it it still does not sort properly. How is this still considered a duplicate bug with this new info? If the file is no longer a CSV then and it is an ODF then why is this still ocurring?