[Libreoffice-bugs] [Bug 108845] New: pasting data from a CSV file didn't work properly: only a single row

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108845
           Summary: pasting data from a CSV file didn't work properly:
                    only a single row
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jsc67 at hotmail.com

Description:
As per
"https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base" 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

-- 
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/20170628/bdf842c5/attachment.html>