The font in the cell is not fully displayed When excel is converted to PDF

Aspose.Cells Product Family
1

Here is a static excel file. When the Aspose interface is used to directly convert to PDF, open the PDF to view. The fonts in the original cells are incomplete in the PDF
image.png (24.8 KB)
image.png (82.2 KB)
image.png (105.2 KB)

Workbook workbook = new Workbook("D://Aspose//SMS_27367//SMS_27367.xlsx");
workbook.save("D://Aspose//SMS_27367//SMS_27367.pdf", SaveFormat.PDF);

The following is the attachment：
SMS_27367.zip (240.4 KB)

2

@xhaixia,

Please add a line to your code segment, it will work fine:
e.g.
Sample code:

Workbook workbook = new Workbook(“D://Aspose//SMS_27367//SMS_27367.xlsx”);
workbook.getWorksheets().get(0).autoFitRows(true);
workbook.save(“D://Aspose//SMS_27367//SMS_27367.pdf”, SaveFormat.PDF);

Also, the suggested line of code will not affect your existing data or produce other issue.

3

@xhaixia,

We evaluated your issue further. We noticed the issue with the used font “DengXian” installed on the machine. We think it seems a bug and it should be fixed in the API. The workaround step we provided to auto-fit rows should be skipped as it should work without it. We have logged a ticket with an id “CELLSJAVA-43723” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

4

@xhaixia,
This is to inform you that we have fixed your issue now. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.

5

@xhaixia

Your issue is fixed in v21.8.2:
aspose-cells-21.8.2-java.zip (7.4 MB)
Let us know your feedback.

6

The issues you have found earlier (filed as CELLSJAVA-43723) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi