https://bugs.freedesktop.org/show_bug.cgi?id=49376

             Bug #: 49376
           Summary: EDITING
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.2 Release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


When using text to columns, converting a date time from a text string AM and PM
is ignored, excel handles the same data correctly.

3/11/2012 5:33 PM is converted to 3/11/12 5:33 AM in calc 

I tried setting the format of the cells before conversion to MM/DD/YY HH:MM
AM/PM before conversion but that didn't help

thanks

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to