https://bugs.freedesktop.org/show_bug.cgi?id=55049
Bug #: 55049
Summary: FILEOPEN: Field delimiter within text delimiters is
not ignored
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 67324
--> https://bugs.freedesktop.org/attachment.cgi?id=67324
An example file containing a reduced test case.
Problem description:
Loading a CSV file that contains the field delimiter (ie: semicolon) within a
text field (ie: double quotes) should ignore the field delimiter. It is placed
within the text-delimiters to indicate it is part of the text string, and
should therefor not be treated as a field delimiter.
We found this bug when trying to load a CSV-export of a database table
containing data stored in PHP's serialized data format.
Steps to reproduce:
1. Create a CSV file with the following contents:
"test";"\";\"";EOF
2. Load the file into Calc.
Current behavior:
File imported as follows (with pipes used to illustrate column separators).
test|\|\""|EOF
Expected behavior:
File imported as follows (with pipes used to illustrate column separators).
test|";"|EOF
Platform (if different from the browser):
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/537.1
(KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1
--
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
