https://bugs.documentfoundation.org/show_bug.cgi?id=139414
Jean-Baptiste Faure <jbfa...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jbfa...@libreoffice.org
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #5 from Jean-Baptiste Faure <jbfa...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
