https://bz.apache.org/ooo/show_bug.cgi?id=126956
Issue ID: 126956
Issue Type: DEFECT
Summary: CSV file not loaded/open correctly when one fields
contains commas surrounded by double quotes
Product: Calc
Version: 4.1.2
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 85528
--> https://bz.apache.org/ooo/attachment.cgi?id=85528&action=edit
Example of file where some fields contains comma and are surrounded by double
quotes
I have CSV file (please see attachment) where some data fields contains comma
as part of text. Data in such fields are surrounded by double quotes (") as per
http://www.ietf.org/rfc/rfc4180.txt. This shall ensure they are taken as part
of single field content. Unfortunatelly Calc does not comply with specs and
breaks text. If I use different delimiter (like tab, semicolumn, etc.) than all
works fine. BTW Google sheets loads supplied file just fine.
--
You are receiving this mail because:
You are the assignee for the issue.
