Forums

Corrupt fonts when CSV exported

Permalink
I use typical form to get some data, but when this is exported Unicode fonts were corrupt. I record a video and saved it in my Dropbox.

https://www.dropbox.com/s/1kid6dfmf70gtoe/c5Bug.mp4?dl=0...

The version is 8.4.2

The data all visible good in the email, in view. Only bad in CSV.

1 Attachment

harun
 
mlocati replied on at Permalink Reply
mlocati
The problem is that Excel does not recognize the UTF-8 character set.
You can try to use LibreOffice Calc.

In any case, with the upcoming concrete5 version 8.5 you'll be able to configure concrete5 to write Excel-compatible CSV files (you'll need to enable the "Include the BOM (Byte-Order Mark) in generated CSV files" option in the dashboard/system/files/export_options dashboard page).