Why can I not open csv file as comma delimited?

English
, , , ,
#1

In the previous version, when I wanted to open a csv file, I was able to select Comma as the separator and it would show the fields in the lower portion of that dialogue box. Since I upgraded to 4.0.4, the fields are merged into 1, with an arrow (->) inserted between the fields. When the file is opened, all fields are in 1 column.

Here is how the dialogue box looks when Comma is selected (2 files):

Each file has 2 fields. The file showing 2 fields correctly was created with the previous version of LO. The file showing the merged 2 fields was created with the latest version.

Is this a bug?

#5

@netmarketer, I have added a link to your bug in your answer, but unfortunately (according to the comments in the bug report) your original file contains Tabs as the separating characters and not Commas. If you are wanting to change these characters from one type to another it is often best to do this externally to LO, however it can be done using these steps:

  1. Import your CSV file into Calc using Tab as a separating character.
  2. File > Save As… > select the File type of “Text CSV”.
  3. Click Save button.
  4. Confirm “Use Text CSV format”.
  5. On the Export Text File dialog, set the Field delimited to a comma and other settings as required.
  6. Click OK.

If this solves your issue, please RESOLVE your bug as NOTABUG. Thanks.

#2

It seems you should report a bug. Check also the question “How do I see if a bug has already been reported?” and the wiki on details for bug reports.

#3

Thanks. I did eventually report the issue as a bug.

EDIT: fdo#67049 is the related bug.

#4

Please edit your answer and report the bug number according to the following instructions. You can then proceed to accept an answer by clicking on the little check-mark to the left of the answer. Voting is accepted, too :slight_smile:

#6

I had the same problem, this is how I handles it:
Save the file again with a .csv extension.
Double click to open → everything goes from here as it used to (you get to choose the delimiter and see a preview).
B.T.W I’m on Ubuntu 14.04

Good luck, hope this helps someone!

Al

#7

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.