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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbfaure at libreoffice.org
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #5 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
(In reply to Jonny Grant from comment #4)
> [...]
> 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.

I disagree, it is up to the user to choose the date format suitable for his
purpose. The year coded with 2 digits may be ambiguous or not, depending the
meaning of the data. If your data is about genealogy using 2 digits for the
year is a very bad idea. If your data are about your bank account, there is not
ambiguity about a 2 digits year.

I think there is another problem with your request. It is like if you wanted
that the date value reveals its date format. That is not possible with CSV
format.
For example, its clear that the format of 2021-01-13 is YYYY-MM-DD, but for
2021-01-12 you can't decide between YYYY-MM-DD and YYYY-DD-MM and there is
nothing in the CSV format that gives you a mean to decide. The only mean is to
put yourself the date format information in the header of the date column.

Calc can't do that work for you because it knows nothing about the meaning of
the data.

So for me there is no bug here and I close this bug report as Not-A-Bug. Please
feel free to reopen if you disagree.

Best regards. JBF

-- 
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/20210510/422f527b/attachment-0001.htm>