[Libreoffice-bugs] [Bug 48621] New: FILEOPEN: CSV: better handling of broken CSV files with unescaped embedded quote delimiters

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48621

             Bug #: 48621
           Summary: FILEOPEN: CSV: better handling of broken CSV files
                    with unescaped embedded quote delimiters
    Classification: Unclassified
           Product: LibreOffice
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: erack at redhat.com


CSV files not strictly following the CSV specification, regarding embedded
quotes inside a quoted field are to be doubled, easily trick the import into
not distributing following content as the generator intended it to be.
Implement some magic to detect and correct at least some of those cases to
prevent data loss.

Related:
https://issues.apache.org/ooo/show_bug.cgi?id=78926
and attachments.

Another test case mentioned there, originally from
https://issues.apache.org/ooo/show_bug.cgi?id=80385
with attachments:

,"abc" d "ef",
currently results in
'abc d "ef"'
To not lose data it should result in
'abc" d "ef'

Doing so would also lead to
,"a"b, "a",
resulting in _one_ field
'a"b, "a'
and not two, 'ab' and ' "a"' like it is currently the case. This would then
differ from how Excel treats it, but would be more consistent.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.