PDF from Excel - French chars not displayed correctly in Linux

Hi,

We are using Cell-8.1.2 jar to create excel and then pdf from excel.

As per our requirement, we have to write french charancters in excel and pdf

--> When we test the application from windows, it correctly generates Excel and PDF both with french characters.

--> But when we test application from Linux, it correctly generate Excel with french character, but when we generated PDF from excel, it does not display french character propertly. The interesting thing is when we copy characters from PDF and paste to notepad, it displayed correctly. That means the issue is with display in PDF

regards,

Hi Esha,

Thanks for your posting and using Aspose.Cells.

It is actually the issue of Fonts. You need Arial MT (simply Arial) font. Just get it from your Windows Fonts directory and place it in your Linux Machine in some directory.

Suppose, you place it in /usr/share/fonts/mydir then you will have to set it with CellsHelper.setFontDir() like this

CellsHelper.setFontDir(“/usr/share/fonts/mydir”)

Now
Aspose.Cells will use the fonts in this directory while converting your
Excel into PDF and your symbols will properly be converted.

Please also see the following article for your more help.

( Aspose.Cells Font Usage|Documentation )

Please also see the image attached by me that illustrates what fonts you need related to this issue.