NPrinting: Excel Rows are not automatically resized in reports

[tanmay_bhardwaj]

I cannot auto-resize the cells in the Excel sheet generated via NPrinting.

I followed the same instructions as given in this article but they aren't working:

https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Excel-Rows-are-not-automatically-r...

Please advise how to troubleshoot this issue.

My environment details are as mentioned below:

Qlik NPrinting May 2023 SR3

Version: 23.20.9.0

Qlik NPrinting 

[Lech_Miszkiewicz]

Hi @tanmay_bhardwaj 

We dont see your template so it is hard to see what you do wrong. I will just say that it works for me so it is not bug or issue with the version. 

It really depends how you built your template, how you use properties and excel settings, whether you use "Keep source format" or not...

Sharing the screeenshot of your template and a result + expected result screenshots would definitelly help (you can scramble sesitive data if there is any)

cheers

[David_Friend]

@tanmay_bhardwaj yes can you share some screenshots? That article should have resolved this!  Have you done any recent upgrades?

[tanmay_bhardwaj]

@Lech_Miszkiewicz  and @David_Friend , below are the images from NPrinting Report viewer and the final XLS generated in the email. If you see the excel data (i have masked it) there is lot of white space in the cells, data in the 'Material Description' column is wrapped too.

[Lech_Miszkiewicz · Accepted solution]

Hi @tanmay_bhardwaj 

As mentioned in my previous message we need to see properties which we still dont see in your screenshot. I have market them in box and labeled (1). There in that area you normally would setup how field needs to behave and for keeping excel format you would have to disable "KeepSource format" for all the columns (i marked them as (2) ) you have in template.

We dont see if you do that because you dont show us this information.

As always please refer to help site for details regarding all those properties: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/ReportsDevelopment/Designer-pro...

cheers

[tanmay_bhardwaj]

Hi @Lech_Miszkiewicz ,

Thanks for your reply and apologies for missing the details of the table. Yes, you are correct, the checkbox for 'Keep Source Formats' was selected. After I removed the checkbox and selected AutoFit Column Width and AutoFit Row Height, the cells in the excel sheet got resized. But in some of the cells where I have longer text description, the text size is automatically reduced as you can see in the screenshot below. How can I solve this problem?

[Lech_Miszkiewicz]

regarding different size of font i am assuming you have set "Shrink to fit" setting. You may also disable it. 

[tanmay_bhardwaj]

@Lech_Miszkiewicz , thanks for your reply, it solved my problem!