[Libreoffice-bugs] [Bug 139414] New: Calc exports CSV dates as 11/10/09

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jan 4 22:44:14 UTC 2021


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

            Bug ID: 139414
           Summary: Calc exports CSV dates as 11/10/09
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jg at jguk.org

Can Calc export dates using the sensible ISO 8601 format?
When opening these CSV files containing 11/11/11 it is anyone's guess if the
reading software will get it right.

This bug is easy to reproduce

1. Type:  11 Oct 2009
2. Observe the cell shows 11/10/09
3. Export as CSV, observe the file contains: 11/10/09


What I expected was the sensible format:  2009-10-11 the format is well
defined, YYYY-MM-DD

-- 
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/20210104/5c5f0081/attachment.htm>


More information about the Libreoffice-bugs mailing list