To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95959 Issue #|95959 Summary|accept TSV as a file type for open and export (besides | CSV) Component|Spreadsheet Version|OOo 3.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|zhangweiwu
------- Additional comments from [EMAIL PROTECTED] Fri Nov 7 12:47:25 +0000 2008 ------- The TSV file format definition is very simple: http://www.iana.org/assignments/media-types/text/tab-separated-values TSV has a particular advantage over CSV, which is simplicity. In my projects I often find users who were supposed to manipulate data exported from other systems are often confused with multiple options provided by CSV, e.g. text delimiter, field delimiter. gnumeric recognizes .tsv format and opens without asking user a single question like the text delimiter (because there is none, tab-separated-values do not distinguish text and digits) or field delimiter. This gives advantage for system implementors like me to provide user with TSV format with the confidence user will ask less questions to support team or mess up data by answered wrongly about text delimiter. I think OOO should do alike. Furthermore although TSV format did not specify what is the EOL, I recommend always default to CRLF (despite OS difference) for two reasons: 1) more application accepts CRLF than CR or LF; 2) it provide the convenience that non-Windows users can process the TSV file with text tools like AWK, using CRLF as record separator would let them accept table cells that contain linebreak in either CR or LF. It's not necessary to add TSV available in "Sheet from File" function because those who use that function is probably aware of the delimiter concepts. --------------------------------------------------------------------- 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]
