[Libreoffice-bugs] [Bug 131377] New: Not Sorting Dates Correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131377
           Summary: Not Sorting Dates Correctly
           Product: LibreOffice
           Version: 6.4.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: c319chris at aol.com

Description:
Windows 10: Version: 6.4.1.2 (x64)

In Calc, when pasting dates from imported .csv file, cell format changes from
previously-chosen "date" format to "text" format. Dates then acquire a leading
apostrophe: '03/11/2020, making it impossible to change the text formatting
without manually editing the cells to remove the leading apostrophe. Converting
dates to text strings can cause dates to be sorted incorrectly even though the
dates are displayed correctly. This happens even if cells have been previously
formatted as "date" format.

Steps to Reproduce:
1. Import list of dates from .csv file formatted as 03/10/2020
2. Note that dates now have a leading apostrophe.
3. Choose Data->Sort Ascending or Data->Sort Descending

Actual Results:
See above.

Expected Results:
Dates should retain date format and be correctly sorted.


Reproducible: Always


User Profile Reset: No



Additional Info:
Dates should retain date format and be correctly sorted.

-- 
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/20200316/719fc42c/attachment.htm>