0

I have a CSV file that looks like this:

"column1",,"column3"
"column1",column2,

Sometimes the CSV contains blank column(s). Is it possible to open it correctly in Open Office?

1
  • As Mike's answer indicates, this should work. To determine why it's not in your case, you will need to provide specifics on exactly how you're doing it.
    – fixer1234
    Commented Nov 8, 2017 at 20:11

1 Answer 1

2

It works perfectly well for me in Apache OpenOffice Calc v. 4.1.4, as well as in LibreOffice Calc v. 5.0.4.2 and Microsoft Office Excel 2007. You will face a popup window once you try to open the CSV file and you have to ensure that in your case you have "comma" selected as the separator.

Apache OpenOffice Calc v. 4.1.4:

enter image description here enter image description here

LibreOffice Calc v. 5.0.4.2:

enter image description here enter image description here

Not the answer you're looking for? Browse other questions tagged .