To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61711 Issue #:|61711 Summary:|CSV export does not quote properly on mixed-type data |in a column Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|spreadsheet Reported by:|eclypse
------- Additional comments from [EMAIL PROTECTED] Mon Feb 6 14:06:39 -0800 2006 ------- When exporting from Calc to a .csv file with a column type that has mixed data types (i.e. some rows are alphanumeric and some are strictly numeric), only rows that are alphanumeric are enclosed by quotes. Rows that are only numeric are not enclosed in quotes, even when the format for the entire column is set to text. This is causing inconsistencies in the behaviour of other programs that are importing this data and that is what brought it to my attention. I tested on WinXP and FC4 with OOo 2.0. Example: Col1, Col2, Col3 1234, 12A1, abcd 1235, 12B2, efgh 1246, 0691, hxyh CSV output will look like this: 1234,"12A1","abcd" 1235,"12B2","efgh" 1246,0691,"hxyh" --------------------------------------------------------------------- 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]