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
FormBrowser export to xls don't show correct characters
Re: FormBrowser export to xls don't show correct characters
No solution for this.
Søren
Søren
Re: FormBrowser export to xls don't show correct characters
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
- 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
-
yurayurayura
- New Member
- Posts: 2
- Joined: Fri Jun 08, 2012 5:43 am
