To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88243 Issue #|88243 Summary|Import csv as text, sets a field as date Component|Spreadsheet Version|OOo 2.4.0 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|higuita
------- Additional comments from [EMAIL PROTECTED] Sun Apr 13 21:59:47 +0000 2008 ------- I tried to import a file as csv and used the standard and when the file was imported, the file contained several fields as date, other as text... so i tried to enforce the text import for all column, but still i saw several entries as date. i tried to reduce the file to a text case that i will submit next. if i remove one more line from the top, OOo 2.4.0 opens the file correctly. In the test case the last line few lines show the problem, where several values are text and one of then is set as date. even worst, there isnt any easy fix for the wrong conversion, trying to convert to text or number gives a totally different result, forcing the user to hand correct the value if i set that all column are text, OOo shouldn't try to do ANY detection of format, so this is a bug i'm using linux 64bits (slamd64 - slackware in 64bits), but OOo is 32bits, the binary packaged downloaded from the OOo site. i dont have windows, so i cant test in another OS --------------------------------------------------------------------- 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]