GNOME Bugzilla – Bug 72416
Quotes misbehave when loading CSV files
Last modified: 2004-12-22 21:47:04 UTC
The following was reported as a bug through the Debian BTS. Note that there is a seperate bug for the first problem already (id 71783). From: Frederic Briere <fbriere@abacom.com> Subject: gnumeric: Quotes misbehave in CSV format Two problems regarding quotes: 1) When writing in CSV format, quotes are always doubled, even when selecting "Never" quoting. Intuition would assume otherwise. 2) When reading a sheet that was saved in CSV, with default options, double quotes are not appropriately recognized: a ""quoted"" string, and a single quote ("") in a cell." Becomes: "This is a ""quoted"""" string", "and a single quote ("""") in a cell.""" (I've got a *lot* of manual corrections to do...) From: Frederic Briere <fbriere@abacom.com> Subject: Re: Bug#130224: Acknowledgement (gnumeric: Quotes misbehave in CSV format) I should amend my statement a bit; *importing* a CSV works fine, but *opening* one does not. Given that one expects to be able to open any file that one saves (save/open vs. export/import), I still think it is a bug. (I realize that there are many flavors of CSV, but failing a magical heuristics that would get it right everytime, I propose that Gnumeric either assume its default format was used, or present a dialog like it does when importing.)
*** Bug 71783 has been marked as a duplicate of this bug. ***
The 2nd issue is just inherent to the way Gnumeric works, It's not really a bug. The 1st, however, is. There is more to it than meets the eye. In fact there a two distinct problems : 1) The exporter always uses " as the quoting character even when another one is selected. 2) The exporter quotes even when it shouldn't. A patch which resolves both issues has been sent to Jody and will be committed to CVS once he approves.
Fixed in both 1.0.x (will be in 1.0.5) and 1.1.x