# Is there a bug with empty commas for csv import? [closed]

If I have a csv file with the following data

"col1","col2","col3","col4","col5","col6","col7","col8"
"x","x","x","x","x","x","x","x"


libre calc imports it fine

But If I have empty commas, it breaks. The preview for import looks ok but when it actually processes, it basically takes all following data and places it into the column before the commas. 4 of the commas are removed and the data just has the remaining commas and ALL other data in the column now.

"col1","col2","col3","col4","col5","col6","col7","col8"
"x","x",,,,,,"x"


See video: http://screencast.com/t/hALFEe1g

The video pretty much confirms the issue

I can work around it by added empty quotes "" instead of nothing. Perhaps libre calc just doesn't support empty commas the same way excel does?

edit retag reopen merge delete