Problem with Chart.toImage and Chinese symbols

Aspose.Cells Product Family
1

Hello,

I try to create chart with Chinese symbols and convert to image and insert to word and PowerPoint formats, but i can’t read chinese simbols in image after converting.

Aspose cells 7.1.2

in attachments simple example.

2

Hi,

Please download and use the latest version:
Aspose.Cells
for Java v7.1.2.5
and let me know your feedback.

I have tested it with the latest version and I think, it is working fine.

Please see the output image generated by your code with the latest version.

3

Try to use this "百分比"
Previous example not a chinese symbols.

4

I try to use 7.1.2.5 and no effect.

5

Hi,

It seems, this is the issue of fonts.

Please set the font directory or font path using the following methods. Then it will work fine.

CellsHelper.setFontDir(“c:\windows\fonts”);

or

book.getSaveOptions().setFontPath(new String[]{"/home/usr/test/winfont"});


6

Hello,

I can create chart with chinese symbols in excel and it’s looks fine, but if i try to convert chart to image, i got this.


7

Hi,

Your problem should have resolved after setting the fonts path or directory.

Anyway, I have forwarded your issue to our development team.

I have logged this issue in our database. Once, we will have some code or any update available for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40169.

8

Hi,

The default font name of chart is “Arial”.

“Arial” does not support Chinese.

You can modify the default font to display Chinese by the following code.


chart.getTitle().getFont().setName(“SimSun”);

chart.getCategoryAxis().getTickLabels().getFont().setName(“SimSun”);

or
chart.getTitle().getFont().setName("宋体");

chart.getCategoryAxis().getTickLabels().getFont().setName("宋体");