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@lists.freedesktop.org ReportedBy: er...@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. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs