topic Re: Nprinting designer column width issue in Qlik NPrinting

Nprinting designer column width issue

Ri_ta — Wed, 25 Sep 2019 18:40:54 GMT

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?

Re: Nprinting designer column width issue

Ruggero_Piccoli — Thu, 29 Aug 2019 13:52:00 GMT

Hi,

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

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

Best Regards,

Ruggero

Re: Nprinting designer column width issue

Ri_ta — Thu, 29 Aug 2019 14:49:06 GMT

Thanks, that did it!

Re: Nprinting designer column width issue

Prateek5 — Fri, 04 Apr 2025 15:46:06 GMT

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?

Re: Nprinting designer column width issue

Ruggero_Piccoli — Mon, 07 Apr 2025 10:25:33 GMT

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