|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | reading .csv dates depends on language | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | TAB <TorrAB> | ||||
| Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||
| Status: | CONFIRMED --- | QA Contact: | |||||
| Severity: | Normal | ||||||
| Priority: | P3 | CC: | kschenk, TorrAB | ||||
| Version: | 4.0.1 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | All | ||||||
| OS: | All | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | 4.1.0 | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
Using Linux-32, version --
AOO411m1(Build:9770) - Rev. 1604099
2014-06-30_07:13:14-Rev.1606633
4.1.1-dev
Confirmed that something very odd is happening here.
When I change the type of field from "standard" to "date" when opening the csv (on import), everything is fine in either version of English -- US or CA.
When I leave the field definitions unchanged on import, even I try to change the definition for what we assume is the date column -- Column A -- after opening, nothing happens. No change in date format.
So why? Then I notice on import with this option, no additional field specification on import, I see a tick mark (') in the front of the date value thereby throwing the formatting change off. Once I remove this tick mark form both dates, everything works as expected.
I am not sure why this mark was inserted. This DEFINITELY needs attention.
Changed component to "open-import" instead of formatting.
reset field Target Milestone as we are in general set this field when it is more or less 100% clear in which version a solution for the issue will be available. |
Created attachment 83622 [details] 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.