6

Didn't use to happen. Now happens with any upload of csv data, regardless of content (and it isn't Chinese!).

enter image description here

I checked

cat /etc/default/locale
LANG="en_US.UTF-8"

My language settings are all English

enter image description here

2 Answers 2

7

Somehow my character set had got changed from "Unicode" to "Unicode (UTF-8). Changing it back completely fixed this issue

See screenshots:

Before:enter image description here

After:enter image description here

1
  • This was similar for me. "UTF-16" was my default and it gives me one row of Chinese characters, "UTF-8" and pretty much all other character set gives me the expected results. My CSV looks similar to yours in that there are empty columns and rows at the top, so that may be related. May 16, 2017 at 14:29
0

your character set in import page is wrong and should be "UNICOE (UTF-8)"; you have,more probably as a "UNICODE (UTF-16), which is wrong!

when you try import an csv file, you should pay attention to "character set" of the import.

when you click on CSV file to open it, Libre Office open the first import PAGE and ask you how do you what to import it.

Above of this window you see the option "character set; the front of that you see a of different option of setting font as a cascade menu; you should change it and choose "Unicode (UTF-8)".

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .