Librecalc 25.2.0.3 CVS export adding extra data to output - SOLVED

English
, ,
#1

Hi,

CVS exported data has extra data added to data in fields.

example:
Date,Patient_Name,DOB,Phone,Email,Address

becomes:
+ACI-Date+ACI-,+ACI-Patient+AF8-Name+ACI-,+ACI-DOB+ACI-,+ACI-Phone+ACI-,+ACI-Email+ACI-,+ACI-Address+ACI-

This makes it impossible to use in applications that accept cvs import.

Appreciate your help in fixing this.

thanks in advance

Russell

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 64; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

#2

Please upload your .ods and .csv type sample file here.

CSV: Comma Separated Values (not CVS)

#3

Not only, if I read your Patient+AF8-Name right. This would hint to a weird charset-coding. Where +AF8- is _ and +ACI- could go for "
.
Can you show your settings, when you export? (Screenshot).

#4

This is tdf#166208. You have had UTF-8 pre-selected in the import or export dialog, and after an upgrade, the encodings list got a new - Automatic - element at the top (done in tdf#152336), which shifted the selection to the element that was previously above - i.e., now you have UTF-7 selected there. (The unfortunate fact is that in the user configuration, we store not a persistent identifier of the selected encoding, but an index in the list; this makes the selection also break e.g. when you change UI language, which changes the sorted order of that list.)

You have to re-select it in the dialog (for export dialog, when saving as, check “[x] Edit filter settings” checkbox in the file picker dialog).

1 Like
#5

Thanks mikekanski, that is it! The encoding was “WesternEurope ISO-8959”, not UTF-8. Changing the export encoding to UTF-8 sorted it out.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.