Calc fails to import .csv files properly

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

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.