To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95958 Issue #|95958 Summary|export CVS: either provide user option for record deli |miter or default to CRLF Component|Spreadsheet Version|OOo 3.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|zhangweiwu
------- Additional comments from [EMAIL PROTECTED] Fri Nov 7 12:46:02 +0000 2008 ------- According to RFC 4180 CRLF is the record delimiter for CSV format (there is no second option to use only LF). This is based on the well understanding of more number of current application that takes CSV can accept CRLF then those support CR or LF. Current text delimiter seems to be based on the OS's default. A Linux user may wish to prepare a CSV file for a Windows user who happen to use a program that only accept CSV file line-separated with CRLF. In such situation the user is stuck. He have to use posix command "tr" but he probably isn't able to or prefer not to use commandline. A second reason to use CRLF for record separator is it gives user possibility to work with data with line-based software, e.g. awk. One awk user can easily set RS (record separator) to CRLF and not worrying about logics to handle table cells containing linefeed (a cell can safely contain either CR or LF but not together). Since the user is actually using awk, he is more likely using Linux or MacOS, which defaults to CR or LF for EOL (but not both), then this user is going to enjoy the CRLF as record separator. Request: either provide user option for record delimiter (always have CRLF selected by default) or always use CRLF for export CSV files. --------------------------------------------------------------------- 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]
