[Libreoffice-bugs] [Bug 117196] New: CSV import not happening correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117196

            Bug ID: 117196
           Summary: CSV import not happening correctly
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kalm77 at yahoo.com

Description:
My version:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; 
Locale: en-US (en_US.UTF-8); Calc: group

I have the following CSV plain text file, a few lines from which are:

"
Agilent Technologies,
114.49

AbbVie,
28.15

AmerisourceBergen,
20.38

Abbott Laboratories,
236.76"

There are spaces, tabs, newlines, and COMMAS between the text (company names)
and the numbers (P/E ratios).  

I want to open it in calc with ONLY the comma as delimiter. I open the file in
Calc, and select delimiter as ONLY the comma.  Calc doesn't split the two
fields into separate columns (as it should) instead it puts them in separate
rows!

Steps to Reproduce:
in description above

Actual Results:  
Agilent Technologies
114.49

AbbVie
28.15

AmerisourceBergen
20.38

Abbott Laboratories
236.76


Expected Results:
Agilent Technologies|114.49 (in separate column) and SO FORTH


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/63.0.3239.84 Chrome/63.0.3239.84 Safari/537.36

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180424/5dc8481d/attachment.html>