https://bugs.documentfoundation.org/show_bug.cgi?id=173165
Bug ID: 173165
Summary: Explain autodetection of ISO 8601 dates in Text/CSV
import
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Found while looking at bug 172365, quoting my comment from there:
If you use ISO 8601 format, it will be detected as date even if you don't tick
"Detect special numbers" and there is no need to define the column as date.
https://en.wikipedia.org/wiki/ISO_8601
It seems our documentation could use some improvement as this is not mentioned
anywhere and I learned about it by searching within Bugzilla.
The relevant help page is
https://help.libreoffice.org/latest/en-US/text/shared/00/00000208.html (Text
Import)
Info about this:
https://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html
bug 88359
It would be good to explain this both in the help and Calc guide book, with an
example.
--
You are receiving this mail because:
You are the assignee for the bug.
