[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from e...@openoffice.org Fri Oct 2 14:28:31 + 2009 --- Closing dup. - 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
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 User er changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from e...@openoffice.org Fri Oct 2 14:28:05 + 2009 --- There's already an issue for this. *** This issue has been marked as a duplicate of 78926 *** - 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
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 --- Additional comments from piton...@openoffice.org Tue Sep 29 23:47:55 + 2009 --- According to the standard, "If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote." See: http://tools.ietf.org/html/rfc4180 OOo does properly support the standard and import a double quote escaped by a double quote. I recommend that the reporter use a script or macro to transform the input to a valid CSV file before import. Strictly speaking, A backslash is wrong. The requester, however, is asking that OOo be modified to support a method that used to be common. I cannot comment on whether or not this was ever standard, just common. I would be inclined to call this an enhancement request, not a defect report. Test by pasting this into a Calc document: "aaa","b""bb","ccc" "aaa","b\"bb","ccc" - 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
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 User plouj changed the following: What|Old value |New value CC|'kpalagin,plouj' |'kpalagin' --- Additional comments from [EMAIL PROTECTED] Tue Feb 5 05:54:56 + 2008 --- Sorry, the above attachment doesn't belong to this bug. Admins: please remove it from this bug report if possible. - 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]
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 User plouj changed the following: What|Old value |New value CC|'kpalagin'|'kpalagin,plouj' - 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]
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 --- Additional comments from [EMAIL PROTECTED] Tue Feb 5 05:35:51 + 2008 --- Created an attachment (id=51369) another example of the problem - 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]
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 User kpalagin changed the following: What|Old value |New value CC|''|'kpalagin' Summary|CSV import brakes on in-te|CSV import brakes on in-te |xt double-quotes. |xt double-quotes. --- Additional comments from [EMAIL PROTECTED] Thu Jan 10 21:05:00 + 2008 --- Please see http://sc.openoffice.org/servlets/ReadMsg?list=dev&msgNo=2091 and the whole thread. Then consider discussing this in spreadsheet development list. - 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]
[sc-issues] [Issue 84048] CSV import brakes on in-te xt double-quotes.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84048 Issue #|84048 Summary|CSV import brakes on in-text double-quotes. Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|open-import Assigned to|spreadsheet Reported by|stlman --- Additional comments from [EMAIL PROTECTED] Wed Nov 28 12:30:56 + 2007 --- Greetings All. The issue has been discussed in the ticket 31441 but I really would like to reopen the discussion. Let me describe my background a bit. I use a database application which exports data as CSV. I cannot change neither the DB nor the application in any way. There are several columns which contain user-entered text (without any constraints). There are chances that I can make the author of the application export better formed CSV. Which means backslash escaping As far as I know CSV there is a "tradition" to escape special characters with a "\". The tradition wich, unfortunately, OO does not obey. I suggest adding support for backslash-escaping in CSV filters (both import and export). PS. P2 because of data gets lost quite easyli. - 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]