Hi
I don't have Open Office so I can't test, but give this a try:
open csv file with notepad, word wrap off
edit > replace
find what: "
replace with: leave blank
save csv
try import to Open Office
and if you've not done so already, can you try formatting a column in Open office to "number"