Skip to content

GitLab

gnumeric
gnumeric
Closed
Opened by Jim Avera@jim.avera

(REGRESSION) ssconvert CSV reader corrupts multi-line fields

Note: This problem occurs in ssconvert version '1.12.43' but not in '1.12.28'

If ssconvert reads a CSV file with a "quoted multi-line field", and it is not the last field in a row, the remainder of the row is corrupted.

STEPS TO REPRODUCE

1. Download attached file "in.csv"
2. ssconvert '--export-type=Gnumeric_stf:stf_assistant' /tmp/in.csv /tmp/out.csv
3. cat /tmp/out.csv

RESULTS

The field(s) following the multi-line field are corrupted. The input file contained

"First line
Second line
Third and last line","Second Field",Third Field

and the output file contained

"First line
Second line
Third and last line"S"econd Field"",Third Field"

Analogous corruption occurs if converting .csv to .xls

in.csv

Edited by Jim Avera