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!