To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69344 Issue #|69344 Summary|Opening .csv file, double quotes don't stop date conve |rsion Component|Spreadsheet Version|OOo 2.0.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|brf
------- Additional comments from [EMAIL PROTECTED] Wed Sep 6 14:56:03 -0700 2006 ------- Calc normally does "smart" conversion when opening a .csv file. An entry that looks like a date, e.g. '9-20', gets converted to the integer that represents September 20 of the current year. In my case, it represents a range of street addresses, and no conversion is desired. So I surrounded the data with double quotes, '"9-20"'. Calc insists on doing the date conversion nontheless. I tried this with Excel [:-(] and it converts the first case, but respects the double quotes in the second example. Calc is converting "date" fields, even when double quotes should tag them as "text" fields that should be treated literally. Default ".csv" values for separator and text delimiter were used. --------------------------------------------------------------------- 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]
