[Libreoffice-bugs] [Bug 136013] FILEOPEN Importing tsv/csv with no string delimiter causes whitespace only trailing column to corrupt

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from xpusostomos at gmail.com ---
I think its worth adding this comment here rather than opening a new bug...

If you choose tab delimited, and string quote character double quote ( " ),
then the following makes it choke

f1\tf2\t"f3",xxx\tf4

What happens, everything after f3... even to the very end of the file (no
matter how many lines and fields that includes) will get dumped into one cell.
Now one might argue that the above is badly formatted (should quotes end right
at field end?), but this is not the right way to handle it.

Another thing, it wasn't obvious to me in the gui that the string delimited
dropdown list was editable. I think a dropdown list here is pointless and
distracting. Everyone uses either double quote or nothing. I would argue that
as soon as you select tab delimited, this field should default to blank,
because as far as I can tell, the whole internet is agreed that TSV files don't
have a string quote character.

-- 
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/20210315/de263e47/attachment.htm>