<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 - pasting data from a CSV file didn't work properly: only a single row"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108845">108845</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>pasting data from a CSV file didn't work properly: only a single row
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jsc67@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
As per
"<a href="https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base">https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base</a>" I
created a table with 3 fields, opened a CSV with 3 fields, selected all the
data in the CSV file, then went to paste the data into the Base field. There
should have been 10 records, but only a single row was created. When I clicked
outside this row to accept it, I got a popup error message saying, "Error
inserting the new record Value too long in statement [INSERT INTO
"demographics" ("SEXF") VALUES (?)]".
Steps to Reproduce:
1.Put cursor in row to be pasted into,
2. Got to Edit, select Paste,
3. Undo things so that I can move on.
Actual Results:
Cannot paste a table of selected data from CSV into a new Base table. I wish I
could send a screenshot, or the CSV file (only 10 records in it) for more
clarity.
Expected Results:
The bug is reproducible. If there's a trick to pasting data into Base, then
the documentation needs to say how to do so more clearly. Otherwise, it looks
as if this simple task just doesn't work as described, and that to me is the
essence of a bug.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101
Firefox/54.0</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>