I am using a web application that exports a csv file. e.g. (cut and pasted from
the file but with some edits to change the content. The CR/LF's are present in
the export)

==== start snip ====

"Task ID","Task Name","Assigned To","Task Status","Task Details","Start
Date","End Date","Priority","WBS","Percentage Complete","Hours","Created
By","Comments","Artifact ID","Document","Dependency"
"477","Blahblah Testing ","John Doe","Green","Complete testing and problem
resolution for enabling use of
the server function and operation feature
under Linux.","01-Dec-03","01-Dec-04","5","1.7","10","0","Bob Jones","","","",""
"480","Blah Infrastructure ","Jane Doe,person 2, person 3,person 4,person
5","Green","Jane to lead.
Deploy stuff, more stuff, yet more stuff and a repository to the Test
Environment","02-Dec-03","19-Dec-03","2","1.10","35","0","Bob Johns","Still
waiting for a miracle to fix the server.","","",""
"490","System Admin Tool","Fred Flinstone","Green","Define requirements for
SAT","08-Dec-03","08-Dec-04","5","1.11","0","0","Bob Joans","","","SAT
Requirements Draft v1_0.doc",""

==== end snip ====

When importing into MS Excel all the values end up in the correct columns and
rows. When importing into OO values are all over the place. It appears the
import is confused by the CR/LF and/or the commas appearing between the text
delimiters (ie quotes, ")

I have not been able to try this on other OS versions.