To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106520 Issue #|106520 Summary|CSV import in Calc converts numbers to dates Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|robertvdvos
------- Additional comments from robertvd...@openoffice.org Sun Nov 1 08:46:57 +0000 2009 ------- Create a CSV file called "test.csv"with data as below 1.00, 2.00, 3.00, 10.00,20.00, 30.00, 12.12,1.01, 19.09, Start a new Calc Session Open a file, select type "text CSV (*....) Select the file Dialogue 'text import', select options separate by comma The input in calc looks like 01-01-00 01-02-00 01-03-00 01-10-00 20.00 30.00 12-12-09 01-01-09 19-09-09 combinations with decimals <=12 and digits smaller then the number of days per month are interpreted as dates. This conversion is not requested by the user, he (I) expect to see the number representation as defined in the CSV file! Thanks for your help, Robert --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org