Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

A published Nprinting Excel Pivot table shows a different column width than the Designer

Hi,

Whenever I publish a pivot table on Excel, the column widths are changed from what was configured on the Designer?

Is there a way to control this?

I am using the Preview button to visualize the published report.

I appreciate, as always, the enormous help. 

Column Widths on the DesignerColumn Widths on the Designer

Column Widths in Published Excel viewColumn Widths in Published Excel view

 

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

In my opinion this is Excel Pivot Table setting which you have to set in NP designer Excel Template --> Your Pivot table--> Pivot Table Options --> "Autofit column widths on update" - Untick!

 

I tested it and it works for me.

cheers

Lech_Miszkiewicz_0-1632182936493.png

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

2 Replies
Frank_S
Support
Support

Which version of Qlik Sense?

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Lech_Miszkiewicz

In my opinion this is Excel Pivot Table setting which you have to set in NP designer Excel Template --> Your Pivot table--> Pivot Table Options --> "Autofit column widths on update" - Untick!

 

I tested it and it works for me.

cheers

Lech_Miszkiewicz_0-1632182936493.png

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.