GemBox Support Forum

Text not printing correctly from Excel to PDF


I used your online tool at convert Excel to PDF
to convert this spreadsheet to PDF file.

But as you can see in this screenshot, in some cases the PDF has “0” where the XLS has no text. And other places there is a “0” where the XLS does have text.

Are there settings I can change if I buy your library that will fix this?

Hi Harry,

You need to recalculate the formulas before saving your spreadsheet to PDF.
For instance, please check the Formula Calculation example.
I hope this helps, let me know if you have any questions.