Saving an .xlsx file as pdf causes layout issues

Hello,


In an application I’m working on, I have to save an excel file to pdf. This pdf generation works fine, besides the fact that the layout of the generated pdf is different from the original excel file.

I attached the excel file, a generated pdf file and the source code I’m using to create the pdf.

One of the layout issues can be seen on the table headers (compare the ‘Carrier1’ worksheet with the output pdf). The cells displaying the names of the months are too small in the output pdf, while everything is shown correctly in the template excel.


How can I fix this, so the generated pdf is layouted exactly the same as the excel sheet?

Kind regards,
Stijn Van Assche.

Hi,

I have tested your case. Could you try the attached latest version/fix v5.1.2.7, I think the cells displaying the month names are same as MS Excel’s print preview for that sheet.


Thank you.


Hello,

Using the dll you sent, the output looks perfect now! Thanks a lot for your quick reply.

Kr,
Stijn.