To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113421 Issue #|113421 Summary|CSV import does not follow CSV standard. Component|Spreadsheet Version|OOo 3.2.1 Platform|PC URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|guidogam
------- Additional comments from guido...@openoffice.org Mon Jul 26 09:54:43 +0000 2010 ------- A CSV file is made up of fields separated by commas and records separated by newlines. If a field contains spaces, *commas*, newlines or quotation marks it must be enclosed by quotation marks, and the eventual quotation marks doubled. That's it. If a quoted field contains commas, spaces or newlines it must be imported *as is* in a sigle cell. This problem, absent in version 2, is fairly important in Europe, where we use commas as decimal separator. Having read about similar issues, I checked (athough it makes little sense) also that the error shows up with the default character set, here "Europa Occidentale (Windows-1252/winLatin1)". By the way, the import dialog box for CSV files is useless, as the CSV delimiters are well known. --------------------------------------------------------------------- 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