Ask Your Question

Problem displaying certain chinese characters

asked 2017-05-14 14:52:33 +0100

kukuschi gravatar image

updated 2017-05-14 19:39:52 +0100


I need to display certain chinese characters in LO calc. Most characters work fine but some only display as placeholder rectangle or other symbols. They are displayed correctly in other software (note-editor, notepad ++, firefox etc.), but i do not know which font they use for that. I have chinese fonts installed and support for asian languages is activated. I am on win 10 und using LO

Some of the characters are: 𠂌 𠃌 𡱒 ⺆ ⺊ 𠄠 𠀃

Some other characters, and that to me is even more strange sometimes work and sometimes do not, e.g.: 𠮷 𢦏 𠦝

Any clues what to do?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-05-14 19:38:48 +0100

kukuschi gravatar image

It seems that if windows can display a character it does not mean, there is also a font installed that one can use (?)

I now use to find out which fonts contain the needed characters (e.g.: In LO calc BabelStone Han does the job for this character, MingiLiu-ExtB does not (but it should). I will see if i can now find a font for every character that i need.

edit flag offensive delete link more

answered 2017-05-14 18:25:53 +0100

petermau gravatar image

Those rectangles are showing you that you have a valid Unicode character, but the font you are using does not have a character entry for that code. I have little knowledge of Chinese fonts but I tried Gungsuh 倚倜偠傘凔咿孔孰, which I believe is a Chinese font provided with LibreOffice and allows me to insert Chinese characters as above.

The default Liberation Sans on my Linux system, on the other hand does not support Chinese. Anyway, try Gungsuh as a starter.

edit flag offensive delete link more


I have some chinese fonts installed. Gungshu is unfortunately not free so i cannot try it but that should not be the problem. I know there must be at least one font that has those characters (or i would not be able to use them e.g. in the windows text editor etc. ... would I?) but I tried all available fonts and had no luck in libre office (writer and calc). It does also not explain why some of the characters work some times and some times they do not.

kukuschi gravatar imagekukuschi ( 2017-05-14 18:45:56 +0100 )edit

I am assuming that you are using .ods to save your spreadsheets and not .xls or .xlsx. Otherwise you might be hitting font replacement problems which could explain why the characters work some of the time and not others.

petermau gravatar imagepetermau ( 2017-05-15 16:14:45 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-14 14:52:33 +0100

Seen: 383 times

Last updated: May 14 '17