New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Microsoft Excel 2010 doesn't render file with charset UTF-8 #51
Comments
Thank you for the fix, it worked like expected. |
Might this be the reason for rendering öäå with similar artifacts? (Excel for Mac 2011) |
i would think so. give it a shot. |
+1 |
With ng-csv.min.js, a BOM is not prepended. |
@eitetsujo did you try to add |
It can not work for me. |
Another problem about the add-bom is, if I set |
@Mavlarn
That aside I don't understand why export to Excel isn't just a default UTF16 + delimiter, wouldn't that just always work? |
If I compress min version, |
@Mavlarn You are correct. The minified file does have the correct char, but after running it through uglifyjs (version 2.4.10) the char is removed. Update: Should have used uglify-js, not uglifyjs. |
There is a bug in MS Excel where it doesn't honor the charset specified in the CSV file without a Byte Order Mark (BOM).
The fix is as such:
var BOM = "%ef%bb%bf";
var DATA_URI_PREFIX = "data:text/csv;charset=utf-8," + BOM;
I'd love to submit a pull request but I am unable setup the dev env to run the existing tests.
The text was updated successfully, but these errors were encountered: