NPrinting: Excel Rows are not automatically resized in reports

[Sonja_Bauernfeind]

NPrinting may not automatically resize the row high in generated reports, and the content in cells that needs a word wrap can be shown incorrectly. This is common after an upgrade from NPrinting 17 to NPrinting 18 or higher releases.

Environment:

• Qlik NPrinting 

Normally, Autofit is enabled by default in Excel, but this setting may change after an upgrade or for other reasons. In this case, it is necessary to activate it again in order to avoid any layout issue.

Resolution:

The problem can be easily resolved by applying Autofit in the Excel template sheet. Here are step by step instructions:

1. Open\Edit the Excel NPrinting report with NPrinting Designer
2. Select all cells in the sheet using CTRL+A
3. Click on 'Home' in the Excel ribbon bar
4. Go to 'Format'
5. Choose "Autofit Row height"
6. Do the same for all the sheets in the template and for all your Excel reports

See fig 1.

fig 1