Hide Forgot
Created attachment 1120260 [details] csv file imported into libreoffice Calc or Math Description of problem: Import CSV and get Chinese/ Japanese (Asian looking, my apologies for any misplaced assumptions) characters!!! Version-Release number of selected component (if applicable): $ rpm -qa libreoffice libreoffice-4.4.7.2-1.fc22.x86_64 How reproducible: Always since I started using f22 from f20 about the New Year Steps to Reproduce: 1. Have CSV 2. Import into Calc or Math 3. Get really weird stuff Actual results: Really weird stuff - Asian appearing characters all in cell A:1 Expected results: Sensible spreadsheet Additional info: Attached screen shots and original csv
Created attachment 1120273 [details] libreoffice Calc/ Math csv import window
Created attachment 1120274 [details] csv imported into libreoffce Calc
Created attachment 1120275 [details] ods file created by csv import
attachment 1120273 [details] shows that you chose "Unicode (UTF-16)" as character set, you should switch that to a single-byte ASCII superset that actually matches your input file's encoding, "Unicode (UTF-8)"
Oops - buy why isn't libreoffice adopting the system/ user character coding - is that the bug? Never had to think about that before.
(In reply to morgan read from comment #5) > Oops - buy why isn't libreoffice adopting the system/ user character coding > - is that the bug? Never had to think about that before. I very much assume that you accidentally happened to switch that setting in the dialog once to UTF-16 (from UTF-8, presumably), by some unintentional keyboard or mouse interaction. I'm not aware how we would ever preselect UTF-16 here.
It might had happened when opening a file with a UTF-16 BOM, or if content starts with 16-bit values where the high byte represents a control character other than CR,LF,TAB, in which case Unicode UTF-16 is assumed and selected. And the settings are remembered and preselected for the next file to be opened.
Thanks Eike, sounds plausible :) M