Nprinting designer column width issue

[Ri_ta]

Hi,

I'm having trouble with nprinting designer in the excel template. (Nprinting version 19.9.5.0, MS Office 2016).

I have a pivot table but I can't center labels and set the right column width.

This pivot table comes from a straight table in qlik sense.

I've tried with no success:

 - Unchecking "Keep source formats" ;

 - deleting the table, reload the metadata, reopen nprinting designer and build the pivot table again;

 - setting in the page layout the width to 1 page (the table fits in one page but is very tiny);

 - adjusting the column width manually.

What else can I do to resolve this issue? 

[Ruggero_Piccoli · Accepted solution]

Hi,

This is an Excel native feature. In the Qlik NPrinting Excel template:

1. Select a cell in the Pivot Table.
2. Display the Analyze tab of the ribbon.
3. Click the PivotTable tool at the left side of the ribbon. Excel displays some options.
4. Click Options. ...
5. Make sure the Layout & Format tab is displayed.
6. Make sure the Autofit Column Widths on Update check box is cleared.
7. Click OK.
8. Run a report preview.

Best Regards,

Ruggero

[Ri_ta]

Thanks, that did it!

[Prateek5]

I have the same issue but with a normal table not a pivot table. Don't see the Analyze option for it. Could you help?

[Ruggero_Piccoli]

Hi,

The original post is dated 2019 so very old. Please consider to open a new conversation instead of responding to a 6 years old post because the software in 6 years is very different and your specific situation could be different.

I checked your screenshot and it is just Excel so I did not understood how it could be related to Qlik NPrinting. So, in the new post, please invest the needed time to clarify your scenario in using Qlik NPrinting to allow us to understand how to help you.

Best REgards,

Ruggero