[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 #4 from Jonny Grant <jg at jguk.org> ---
(In reply to stragu from comment #3)
> Created attachment 168692 [details]
> 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.

-- 
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/4d301075/attachment.htm>