Description: The attached CSV file is not interpreted correctly. What is strange is that the preview is perfect, but when the file is actually opened, it is not imported correctly Steps to Reproduce: 1. Open the CSV file 2. LibreOffice Calc will show the preview windows. IN "Separator option" select "Separated by", check only the "Comma" check-box 3. Notice that the preview is perfect 4. Click ok to actually import the file 5. Actual Results: The file is not imported correctly. For example, in the "CUM_FREQ" column, decimal separators are missing. Also in the "% Frequency" column, decimal separators are missing Expected Results: Decimal separators to be present in both columns Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 157334 [details] The CSV file in which the problem happens
Created attachment 157336 [details] text import dialog
(In reply to yuilytg7 from comment #0) > Actual Results: > The file is not imported correctly. For example, in the "CUM_FREQ" column, > decimal separators are missing. Also in the "% Frequency" column, decimal > separators are missing > > Expected Results: > Decimal separators to be present in both columns Have you tried to select the column format ? Please have a look at the attachment. Does this solve the problem? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
The issue is that the csv is not in German, where decimal separator is comma, the easy way is to select a language with dot as decimal separator. In addition to the solution proposed by Oliver. if the csv has dates and they are dd/mm/yy 'Enclish UK' is what I select as language to avoid select the type for every column with dates or numbers. If dates are mm/dd/yy then 'English USA' In any case not a bug.
The bug happens if I select "Italian" as language I reformulate the bug as this: some decimal separator are processed correctly, some aren't (although the decimal separator is always the same) Here is another CSV file and a screenshot of the bug. In the screenshot I circled in red the decimal separator that are not processed correctly, and in green some of them that are I use "Italian" as language in the import dialog. If I select "English (USA)" they seem to be all processed correctly (although after the import it changes the decimal separator from the full stop to a comma)
Created attachment 157351 [details] CSV file with the value -0.625 imported incorrectly All the values are imported correctly excep "-0.625" which is imported as "-625"
Created attachment 157352 [details] Import dialog of LibreOffice
Created attachment 157353 [details] Screenshot of the bug
Sure, I didn't explain fine. The language in the import window is for the source csv file, not for the destination file. So there is no other way, or select properly every column type of select an import language that matches the csv format for dates and numbers. For your files 'English UK' as language for import, works fine for me. How the csv file is build doesn't depend on LibreOffice. In any case there is not a bug.