Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ri_ta
Partner - Contributor II
Partner - Contributor II

Nprinting designer column width issue

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? 

Labels (1)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

2 Replies
Ruggero_Piccoli
Support
Support

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Ri_ta
Partner - Contributor II
Partner - Contributor II
Author

Thanks, that did it!