https://bugs.documentfoundation.org/show_bug.cgi?id=172365
Bug ID: 172365
Summary: Detect Date format automatically when importing from
CSV with Detect Special Numbers
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The workaround is to specify the date format
However, where a CSV file contains only:
20/04/2025
there is only one possibility, 20th Apr 2025. (It's not like 11/10 be either 11
Oct or 10 Nov in USA)
Could Calc detect that? "Detect special numbers" is ticked.
Currently it loads and shows
'20/04/2025
ie it shows as text.
--
You are receiving this mail because:
You are the assignee for the bug.