Qlik Cloud Excel add ins

[htchan]

I tried to recreate a pixel‑perfect report using the Qlik Excel Add‑in, but I noticed that the font size appears smaller compared to the report I previously built in Crystal Reports. In addition, the font size sometimes changes dynamically.

Any tips on how to maintain a larger, consistent font size within the same Excel cell, and how to fully utilize the margins on the printed page?

[Lech_Miszkiewicz]

Hi @htchan 

This is not really related to Excel Add-In and it is typical Excel behaviour when you Print Excel file. As PDF output is simply excel Print to PDF you need to understand how it behaves including properties which control it being:

• Print Area
• Size
• Margins
• Set width and Height
• Scale

Those are very tricky as you are always fighting with scaling of some sort and you are never sure that font size is what is set on the cell. This is even more difficult if you are dealing with multiple excel sheets as those are managed by Excel independently and Print areas are also independent.

Here are the links which may help you:

• https://support.microsoft.com/en-us/office/page-setup-71c20d94-b13e-48fd-9800-cedd1fec6da3
• https://support.microsoft.com/en-us/office/scale-the-sheet-size-for-printing-in-excel-for-mac-3ea263...
• https://support.microsoft.com/en-us/office/scale-a-worksheet-34a91eb5-8b4e-4a8a-ab28-b6492012eaae#:~....

If you require pixel perfect capabilities and your font size has to be exact you may need to consider using Pixel Perfect in app reporting feature. https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/PixelPe...

cheers