To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88020 Issue #|88020 Summary|Wrong formatting of dates in CSV import Component|Spreadsheet Version|OOo 2.3.0 RC1 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|sandip
------- Additional comments from [EMAIL PROTECTED] Mon Apr 7 18:05:25 +0000 2008 ------- I searched quite a while on the reported issues here, and I am still convinced that none of the other bugs satisfies my query. To summarize, Ooo 2.3.0(part of Ubuntu Gutsy) makes a mess of dates while importing from CSV files. My bank statements are of this format - here is the test file I am using to duplicate my problem: ============================================================================== 1|04-06-2007|Some Invoice detail | |CR|15,300.00|25,389.57 ============================================================================== (One single pipe separated line above, do correct if it has been wrapped) One irritating problem is that when I have several lines like the above to import, Ooo formats the date in the column in every line differently. Some are formatted as date, some are formatted as text. And no, for some reason I cannot set the column type for each of the fields as it appears to have been disabled for some reason. But the main problem is, unlike what is said in other bug resolutions, the locale doesn't seem to have an effect on the wrong formatting of the column. The date above is in mm-dd-yyyy format, and stands for 6th April 2007. If I set the locale of the document to English(USA), import a test file with just the above line, and then format the column into yyyy-mm-dd format, OOo displays the date as 2007-06-04 or 4th June 2007, which is incorrect. I change the locale to English(India) before importing, it is still the same error. What should I be doing to tell OOo to import this column with the mm-dd-yyyy format and interpret it correctly? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
