<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 - FILEOPEN Importing tsv/csv with no string delimiter causes whitespace only trailing column to corrupt"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136013">136013</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN Importing tsv/csv with no string delimiter causes whitespace only trailing column to corrupt
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>andrew@brainfloat.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When importing a tsv or csv without string delimiters, if the final column
consists of only whitespace it adds corrupt data to that column.
If the final column is empty the row loads correctly. Also if the string
delimiter is set to anything (even if the delimiter character does not appear
in the document) the file loads correctly.
One interesting behavior is initially the csv import dialog doesn't show
corruption in the preview, however if you change any options the corruption
appears.
Tested reproducible on versions 5.4, 6.4, 7.0
Steps to Reproduce:
1. Have CSV/TSV file without string delimiters and with trailing column
consisting of only whitespace
2. Turn off string delimiters in import dialog box
3. Click OK
Actual Results:
Right hand column contains corrupt data
Expected Results:
Right hand column blank
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 24; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL</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>