We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Font Style and Size issue while converting excel to PDF

Hi,
Font style and size is disappears in pdf while converting excel to pdf. I have attached sample files here.
Please help me resolve this.

Font issue.jpg (75.0 KB)

Aspose.zip (77.1 KB)

ReportPDF.pdf (61.7 KB)

@Tharun2104,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-48489 - Font Style and Size issue while converting excel to PDF

@Tharun2104,
Manually save the source file to pdf in Microsoft Excel(see attachment “ReportExcel_Ms.pdf”), then check the font style and size in pdf file, the font style and size are both “Arial” font with regular style and 5.04 font size in Excel and Aspose generated pdf files(see attachment “FontStyleSize.png”).

In other words, the font style and size are same.

ReportExcel_Ms.pdf (24.8 KB)
FontStyleSize.png (55.5 KB)

Ok. Why the last line is disappearing the Aspose PDF?

@Tharun2104,

Yes, the last line is truncated a bit as compared to MS Excel’s result. May be you could auto-fit that merged cell (by setting the AutoFitterOptions.AutoFitMergedCellsType enum accordingly while using Worksheet.AutoFitRow(s) method).

Anyways, we will evaluate it further and get back to you with more details.

@Tharun2104,
We have logged a separate issue as CELLSNET-48531 to investigate the truncated text.

@Tharun2104,

Please check the attached screenshot “lines_screenshot.png”. Actually the cell R18 can only contain 5 lines. However after saving to PDF by Microsoft Excel, there are 6 lines. We haven’t figure out the reasons yet. We are sorry but currently, we can’t fix it.
lines_screenshot.png (13.2 KB)