To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97937 Issue #|97937 Summary|CSV import with text delimiter should import as text Component|Spreadsheet Version|OOo 3.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|dpeastman
------- Additional comments from dpeast...@openoffice.org Sat Jan 10 20:46:24 +0000 2009 ------- When importing a CSV file, the presence of the text delimiter should cause the cell to be automatically treated as text. It is, after all, the primary purpose of a text delimiter to indicate that the value is text. While it is true that you can specify that a column is text during the import process, this can be a real pain and error prone. I frequently want to keep the file in CSV format so it can be shared with other applications -- so I may need to open the same CSV file in OOo many times. Having OOo default to the correct handling would make this much easier. A good example of why this important is handling of postal codes, especially US ZIP codes. These codes often start with 0, and if formated as a number any leading 0's get dropped. Another example is years formated as 2 digits (e.g. '07' for '2007') -- again, if treated as a number, the leading 0 is dropped. It is easy to convert a column from text formating to numeric formating -- but it is relatively difficult to convert a numeric column back to text once the leading 0's have been lost. An alternative solution would be to treat any value with a leading 0 as text. This is less elegant, but might be more compatible with a broader range of CSV exporters. Either of these solutions probably also demands that there be an option in the import to explicitly format a column as numeric. In other words, if the default behavior switches to text under any circumstances, then there needs to be a way to explicitly override that default. --------------------------------------------------------------------- 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
