Problem 1:
“Allow newlines in double quotes” check box is enable. (Default setting)
Type a Double quotation mark ” at the last column, it will be garbled.
No matter if Cell Selection Mode or non-Cell Selection Mode in CSV & DSV Mode.
If disable “Allow newlines in double quotes”, it will be OK.
And if type ” at the other column, it is OK.
Problem 2
“Allow delimiters in double quotes” check box is enable. (Default setting)
Type a Double quotation mark ” at the Cell Toolbar in any column, one Double quotation mark will become two.
If disable “Allow delimiters in double quotes”, it will be OK.
TSV (Tab-separated) mode is OK for above two problems.
Example:
a,b,c,
d,e,f,
