To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116919 Issue #|116919 Summary|Calc import CSV ignores text delimiter Component|Spreadsheet Version|OOO320m19 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|schufty
------- Additional comments from schu...@openoffice.org Fri Feb 11 00:15:02 +0000 2011 ------- My CSV file looks like this... Number, Color, Letter, Sequence, Direction One, Red, , , Up Two, Blue, , , Down Three, Green, Alpha, "A, B, C", West On import, column delimiter is set to "Comma" and the "Text delimiter" field is set to double quotes. Note the fourth column in the third row: it's a quoted comma-delimited list. Calc is importing each element in the list as a separate column rather than importing them all together as a single text value. In addition, it's placing the first double-quote in the same cell as "A" and the second double-quote in the cell with "C". Calc should import the text "A, B, C" as a single cell without double-quotes. It's clearly ignoring the text delimiter. I'll attach screenshots of the import dialog and the resulting CSV in case the above description isn't clear. --------------------------------------------------------------------- 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