[Issue 126033] New: Sorting dates does not take format into account

[bu...@apache.org]

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: issues@openoffice.apache.org
          Reporter: hadouma@gmail.com

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.

[Issue 126033] Sorting dates does not take format into account

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=126033

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |oooforum@free.fr
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from oooforum <oo...@free.fr> ---
Your bug report is being closed as NOT_AN_ISSUE due to a lack of information
which is needed in order to accurately reproduce and confirm the problem. We 
need the following information:

a) Provide a step-by-step procedure to reproduce (the simpler will be the
better)

b) Provide any test case(s) which will help us confirm the problem (like a
sample document)

c) Provide screenshots of the problem if you think it might help

Once all of this is done, please set the bug back to UNCONFIRMED and we will
attempt to reproduce the issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 126033] Sorting dates does not take format into account

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=126033

Andreas Säger <vi...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |villeroy@t-online.de

--- Comment #2 from Andreas Säger <vi...@t-online.de> ---
Your cell values are no dates at all. They have been entered, imported or
pasted as text values.

See https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=39529

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.