I am trying to save an excel wordbook into PDF format which contains several accented letters like “é, è, ê” etc… cause it is used for language french.
But the exported PDF file doesn’t display well this kind of words, in general speaking, the PDF file compresses these letters with those just after them (See the attached file).
In excel it is displayed well.
The version I used is 8.0.2 for jdk1.6.
I would like to know without updating to the newest version of Aspose Cells, is there a workaround for which I could resolve this problem?
I am afraid, it is hard to isolate the problem cause without your sample spreadsheet & environment details. Before your provide the above requested, we would request you to try the latest version of Aspose.Cells for Java 8.4.0 for testing purposes only. If you get the desired results against the latest version of the API without making any changes to the code then the problem could be a bug in your current version of the API. However, we still need to investigate the matter thoroughly by converting your sample spreadsheet to PDF in an equal environment as of yours.
I will shortly describe the situation where I apply Aspose Cells.
On a web server (Tomcat 7.0), I use it to create a data table and then save this table in a PDF file. So I choose Cells to create the table then save the workbook as format PDF.
What is strange is that when I execute the generation in my computer, it works perfectly like I imagined. But while deployed on Server, it failed (From the web client, I click the button to generate in order to download this file).
So you know, it is also difficult for me to indicate whether the problem is due to the Aspose APIs or some other libraries. But I will update the version of Cells as you proposed then give you a feedback.
As you have mentioned that the scenario works fine on your local machine but produce incorrect results when application is deployed on the server. Based on this information, I think the problem could be related to the availability of the required fonts on your server. I would suggest you to copy the TTF files from your local machine to any directory (accessible to the application) on your server, and point the API to these TTF files using the CellsHelper.setFontDir method at the start of your application.