<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CSV import not happening correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117196">117196</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CSV import not happening correctly
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kalm77@yahoo.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>