https://bz.apache.org/ooo/show_bug.cgi?id=126805
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from [email protected] --- Excel 2007 imports the fields surrounded with '. Apache Commons CSV can also parse all the lines in this format. AOO parses this too as long as the "Text delimiter" is not ', although it strips the leading ' which seems like a separate bug. What is very impressive is Excel's behaviour when ' is replaced with ". It correctly imports all lines, with the extraneous " inside the text removed. I have no idea how it does this - it must use advanced column and field auto-detection heuristics or something. Neither AOO nor Apache Commons CSV are able to get past line 124. -- You are receiving this mail because: You are the assignee for the issue.
