<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc exports CSV dates as 11/10/09" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139414#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc exports CSV dates as 11/10/09" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139414">bug 139414</a> from <a class="email" href="mailto:stephane.guillou@member.fsf.org" title="stragu <stephane.guillou@member.fsf.org>"> stragu</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=168692" name="attach_168692" title="Screencast of test with LO 7.0.4.2">attachment 168692</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=168692&action=edit" title="Screencast of test with LO 7.0.4.2">[details]</a> Screencast of test with LO 7.0.4.2 Does the formatting depend on the used locale? In my test (see video), I get the date recognised, and the value shown in the spreadsheet is 11/10/09, but the actual value in the field is 11/10/2009. When saving as CSV (File > Save as...), keeping "Save cell content as shown" unticked, I get the full "11/10/2009" in the resulting CSV. If you tick "Save cell content as shown", you will only have "11/10/09" in the resulting CSV (as expected). I agree with you though, the format should be unambiguous, and an ISO standard would be ideal, but the reality is that a lot (/most of?) the users are used to reading the format DD/MM/YYYY, so having it as a default might make sense. But if saving to CSV _does_ reduce 2009 to 09 (with "Save cell content as shown" not ticked), that _is_ a case of data loss, but I can't reproduce on: Version: 7.0.4.2 Build ID: 00(Build:2) CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Ubuntu package version: 1:7.0.4_rc2-0ubuntu0.18.04.2 Calc: threaded Could you check that "Save cell content as shown" setting, and try on the latest version of the LO 7.0 ?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>