[Libreoffice-bugs] [Bug 139440] Calc 'Sort Ascending' does not properly sort when the field is date by mm/dd/yyyy

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139440

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com

--- Comment #2 from Ming Hua <ming.v.hua at qq.com> ---
When opening the .csv file, did you import the "Date" column as "Date (MDY)"
format, or did you just leave it as "Standard" format?

If you don't specify its format and just import as "Standard", it will be
imported as text, and of course will be sorted as text strings, not as dates.

(In reply to john.oliver.3 from comment #1)
> Created attachment 168715 [details]
> .csv file to demonstrate improper data sort (data ascending).
This sample file sorts correctly, 2021 dates after 2020 dates, if I specify
"Date" format when importing.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210106/1b9382be/attachment-0001.htm>