Page 1 of 1
FormBrowser export to xls don't show correct characters
Posted: Sun Jan 16, 2011 8:57 am
by tilde
When I do an export to xls file the characters is not correct in Excel.
I need to show the characters in danish language.
How do I fix this?
Søren
Re: FormBrowser export to xls don't show correct characters
Posted: Wed Jan 19, 2011 3:26 pm
by tilde
No solution for this.
Søren
Re: FormBrowser export to xls don't show correct characters
Posted: Thu Jan 20, 2011 2:49 pm
by zigge
Two options:
- edit the module code to replace the unicode characters to latin-1 using string replace. Did that before, but the easier option is to:
- save the CSV to disk, open excel, choose import from file, select the file, and in the dialog where you define field delimiter, you now can choose encoding in a dropdown. Choose utf-8 and you should have it correct. Works for me(swedish chars)
Mats
Re: FormBrowser export to xls don't show correct characters
Posted: Fri Jun 08, 2012 7:05 am
by yurayurayura