Created attachment 112924 [details]
Example file which fails in UTF-16
This makes LibreOffice interpret the file incorrectly as Chinese characters. This is fixable by changing the encoding, but it's pretty confusing if you don't know what encodings are, and I'm not sure why UTF-16 should ever be a default for a text-based file format.
So, I haven't had coffee yet. Of course it fails in UTF-16, but the problem is that after upgrading 4.3 to 4.4, the default encoding changed to UTF-16, which "broke" CSV importing.
I've heard about this (on Reddit I guess), yet for me your .csv suggests UTF-8 and not UTF-16.
Win 7 Pro 64-bit, LibO Version: 22.214.171.124
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Build ID: 309574394bd4ae3e9e10e5ff0d64bdd7bbbc8b83
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-29_23:44:46
Ubuntu 14.10 64-bit Version: 126.96.36.199.alpha0+
Build ID: 8fd9c25ac66dd238d4c68be3974241a18cb21705
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2015-01-27_22:43:15
When I open your file in Version: 188.8.131.52
ID build: de093506bcdc5fafd9023ee680b8c60e3e0645d7
then LO offers WIN-1250 as default. WIN-1250 is default for Locale: cs_CZ. Your file is in UTF-8.
The same in Version: 184.108.40.206.alpha0+
Build ID: 1845b6af3991ca5521eef48aafe1d0489e2ff8f6
TinderBox: Win-x86@42, Branch:master, Time: 2015-02-02_09:30:48
No problem in Linux, character set correctly recognized as UTF-8
=> on Windows Cals fails to recognize encoding of .csv file and offers default encoding from windows enviroment.
*** This bug has been marked as a duplicate of bug 82418 ***