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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from stragu <stephane.guillou at member.fsf.org> ---
Created attachment 168692
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168692&action=edit
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 ?

-- 
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/20210105/29bf100e/attachment.htm>