Red Hat Bugzilla – Bug 1303781
libreoffice calc and math appears to translate csv to some other Asian in appearance (to me) language
Last modified: 2016-03-28 07:38:34 EDT
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
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
Really weird stuff - Asian appearing characters all in cell A:1
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 :)