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