https://bugs.documentfoundation.org/show_bug.cgi?id=141155
Bug ID: 141155
Summary: FILEOPEN: CSV file ignoring enclosing chars
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dandekar.ab...@gmail.com
Created attachment 170615
--> https://bugs.documentfoundation.org/attachment.cgi?id=170615&action=edit
Combined pic
Hi All,
I have a CSV with comma in data. The data is correctly enclosed with
double-quotes.
CSV data is :
"This is a single, cell"
While importing a CSV file with enclosing chars, the preview shows the data
correctly. Shown in pic_import_preview.png
But after the calc opens, it puts the data in two different cells. Shown in
pic_open_calc.png
This is major, because once a user opens such a file and accidentaly saves it,
calc adds an additional comma separator whereever the data is not with commas.
i.e a new column gets added in the CSV file. This will lead to data error for
all the downstream applications which are not expecting those columns.
Below are the version details:
Libreoffice calc
Version: 6.4.6.2
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 12; OS: Linux 5.8; UI render: default; VCL: gtk3;
Locale: en-IN (en_IN); UI-Language: en-US
Calc: threaded
~Abhay D
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs