https://issues.apache.org/ooo/show_bug.cgi?id=126033
Issue ID: 126033
Issue Type: DEFECT
Summary: Sorting dates does not take format into account
Product: Calc
Version: 4.1.1
Hardware: Mac
OS: Mac OSX, 10.9
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
When I sort a sheet on a column, containing a date in the format dd-mm-yyyy and
the date format is specified as DD-MM-YYYY as well, sorting does not take this
into account. Instead of sorting on yyyy-mm-dd as it should, it will still sort
on dd-mm-yyyy, meaning the resulting sequence will be all 1st day of all
months, flowed by all 2nd days of all months, etc.
The date format should not only be used "so it looks nice", but also to
indicate where the date components (dd, mm and yyyy) are
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
