Calc fails to import .csv files properly

asked 2016-06-22 11:18:52 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi everybody,

I have a .csv files where the data is separated by commas. The decimal separators are points. When I try to import the file in calc something strange happens:

  • in the preview window every cell is recognized correctly
  • after the import some cells don't contains decimal separators (e.g. original: 39.999 imported: 39999) but only on a few

does everyone get the same error and/or has a solution? As I said, in the preview-windows everything seems fine.

Greetings Ivan

edit retag flag offensive close merge delete

Comments

Without a couple a sample file with a couple of lines showing the issue, to test. I think not possible. Or past here the lines.

m.a.riosv gravatar imagem.a.riosv ( 2016-06-22 16:40:00 +0100 )edit