Excel to PDF not converting with correct symbol

Hi Team,
In my project, we are generating the excel report using aspose cells.

For displaying the flag, I am using the following font setting.
Font Name : Wingdings
Color : Red
Font : "O"

Using this setting, I get the flag in the excel file.
But when i generate the pdf from this excel using following setting in java, its not displaying the flag, Instead it is showing "O" in the pdf file.

response.setContentType("application/pdf");
response.addHeader("Content-Disposition", "attachment; filename="+ "XXX.pdf");
final XlsSaveOptions options = new XlsSaveOptions(SaveFormat.PDF);
Workbook.save(response.getOutputStream(), options);
response.setContentType("application/pdf");
response.addHeader("Content-Disposition", "attachment; filename="+ "XXX.pdf");
final XlsSaveOptions options = new XlsSaveOptions(SaveFormat.PDF);
Workbook.save(response.getOutputStream(), options);

Can you please tell me , why this is happening?Is there any settings i need to apply?

Thanks in advance,
Hardik Shah

Hi Hardik,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for Java 8.3.0.3 and the attached input spreadsheet. You may observe from the resultant PDF file that the flag has been rendered fine. In order to investigate this scenario further, we would request you to please provide us your input spreadsheet or the code to create the spreadsheet along with the resultant PDF generated on your end. Moreover, please provide the environment details such as follow.

  • Operating System version
  • Operating System architecture (32bit/64bit)
  • JDK Type (Sun/OpenJDK)
  • JDK version

Hi,

I was using aspose cells 7.3.4 version. My issue got fixed with the Aspose cells version 8.1.2.

Thanks

Hardik Shah

Hi,


Good to know that the latest version fixes your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.