[Libreoffice-bugs] [Bug 141155] New: FILEOPEN: CSV file ignoring enclosing chars

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: dandekar.abhay at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210322/8cdf6303/attachment-0001.htm>