<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#c4">Comment # 4</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:jg@jguk.org" title="Jonny Grant <jg@jguk.org>"> Jonny Grant</a> <pre>(In reply to stragu from <a href="show_bug.cgi?id=139414#c3">comment #3</a>) > 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 ? My apologies I am not using a newer release of LibreOffice. It sounds like "Save cell content as shown" would work, is that ticked by default? Although, it's quite a manual process to require us to set a sensible format before saving dates. This is basically a millennium bug still existing in Calc.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>