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

Ming Hua <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #2 from Ming Hua <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to