https://issues.apache.org/ooo/show_bug.cgi?id=125175
Issue ID: 125175
Issue Type: DEFECT
Summary: reading .csv dates depends on language
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83622
--> https://issues.apache.org/ooo/attachment.cgi?id=83622&action=edit
csv file with dates
Read 1403.csv (as provided by my bank) with options: separated by Comma; Detect
special numbers, Language: EngUSA. The dates in col.A have the year truncated
to '14'; they can be converted, eg, to the ISO format, eg: 03/12/14 -->
2014-03-12. Good.
Close the file without saving the changes, and re-read it with: Language:
EngCanada. The dates are now read as text, eg, '03/12/2014', left-justified
(like text, not numbers). They cannot be converted to another date format
unless the leading apostrophe in the InputLine is deleted first.
There should not be such a difference between variants of English.
Besides, the format mm/dd/yyyy is not specifically Canadian; the US government
uses it.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
