[Libreoffice-bugs] [Bug 108845] 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

--- Comment #7 from Alex Thurgood <iplaw67 at tuta.io> ---
@jsc67 : thanks for the information.

However, your CSV file doesn't appear to be in a format that can be recognized
correctly by Base.

The first line contains multiple occurrences of ,, (double comma). Base is
incapable of interpreting this.

It takes the first line as the column names, wherein each field name is
separated by a single comma. If you include two commas, Base can not index that
data stream against the field definitions in your ODB file.

The same goes for your values. You need to separate your data back out into 3
different CSV files again, and then try importing them separately; or else tidy
up your single CSV file so that all of the data can be imported correctly.

-- 
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/20170705/1f83a9b8/attachment.html>