We are using Aspose to generate PDF from Microsoft Excel.
In the Java code, we have the following lines to display the direction symbols and they perfctly showing in the generated excel report where as in PDF we have the issue -The symbols are not correctly decoded, instead of the symbols shown in excel , they are shown different ones as shown below.
Can you please help us understand the root cause of this or any other way doing this. Any samples would be really appreciated to achieve this piece of functionality.
Unfortunately, we are unable to replicate the problem as you may also observe from the attached resultant PDF. We would recommend you to please give a try to the latest version (link shared above). In case the problem persists, we need your environment details such as follow to further investigate the matter.
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.