To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80385
------- Additional comments from [EMAIL PROTECTED] Tue Aug 7 18:24:52 +0000
2007 -------
Please note that all your files are broken csv-files. There are a set of simple
rules in csv-files:
1. text-containing quotes shall be enclosed in quotes
and
the text-quote shall be doubled
e.g. this "-quote must be doubled
=> csv: "this ""-quote must be doubled"
2. the whole field shall be enclosed in quotes
=> therefore "a"b is undefined
I would interpret it as enclosing quotes => ab
[OOo differs here => "a"b]
3. breaks inside a quoted field are considered as part of the field
Therefore, Excel is really broken, but your file is the primary culprit:
1. |test| , |->"a"<-b| , |->"a"<-| , |d->"a"<-c| , |m| , |->"j"<- | ,
|d| , |b->"A"<-| , |D->"E,"<-f| , |1->","<-a| , |b->","<-de->"b,a"<-|
2. |->"abcdef"<- test ->"abc"<-| , |->"def"<-g->"h"<-| , |def->"gh"<-|
3. |->"this is
a test"<-| , |->"yes
it
works"<-| ,
4. |No it doesn't|
5. |->"yes it,"","<-does->","<-no->"
""""a,cd""e
"<-a->""<-???BIG PROBLEM UDEFINED???<-b->"""???<-NO ENDING QUOTE
|<== ??? DOES THE FIELD REALLY END
So, understood?
[OOo has some quirks, too, but it is really the undefined behaviour of your
broken file that is 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]
