https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Excel-Rows-are-not-automatically-resized-in-reports/ta-p/1712518 <P>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.</P> <P>&nbsp;</P> <H4><STRONG>Environment:</STRONG></H4> <UL> <LI><LI-PRODUCT title="Qlik NPrinting" id="qlikNPrinting"></LI-PRODUCT>&nbsp;</LI> </UL> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <H3 class="qlik-migrated-tkb-headings">Resolution:</H3> <P><BR />The problem can be easily resolved by applying Autofit in the Excel template sheet. Here are step by step instructions:</P> <OL> <LI>Open\Edit the Excel NPrinting report with NPrinting Designer</LI> <LI>Select all cells in the sheet using CTRL+A</LI> <LI>Click on 'Home' in the Excel ribbon bar</LI> <LI>Go to 'Format'</LI> <LI>Choose <SPAN class="feeditemtext cxfeeditemtext">"Autofit Row height"</SPAN></LI> <LI><SPAN class="feeditemtext cxfeeditemtext">Do the same for all the sheets in the template and for all your Excel reports</SPAN></LI> </OL> <P>See fig 1.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fig 1" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56582iAA62037CEC7BF29A/image-size/large?v=v2&amp;px=999" role="button" title="autofill row height option.png" alt="fig 1" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">fig 1</span></span></P> <P><SPAN class="feeditemtext cxfeeditemtext">&nbsp;</SPAN></P> Thu, 10 Jun 2021 09:15:32 GMT Sonja_Bauernfeind 2021-06-10T09:15:32Z https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Excel-Rows-are-not-automatically-resized-in-reports/ta-p/1712518 <P>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.</P> <P>&nbsp;</P> <H4><STRONG>Environment:</STRONG></H4> <UL> <LI><LI-PRODUCT title="Qlik NPrinting" id="qlikNPrinting"></LI-PRODUCT>&nbsp;</LI> </UL> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <H3 class="qlik-migrated-tkb-headings">Resolution:</H3> <P><BR />The problem can be easily resolved by applying Autofit in the Excel template sheet. Here are step by step instructions:</P> <OL> <LI>Open\Edit the Excel NPrinting report with NPrinting Designer</LI> <LI>Select all cells in the sheet using CTRL+A</LI> <LI>Click on 'Home' in the Excel ribbon bar</LI> <LI>Go to 'Format'</LI> <LI>Choose <SPAN class="feeditemtext cxfeeditemtext">"Autofit Row height"</SPAN></LI> <LI><SPAN class="feeditemtext cxfeeditemtext">Do the same for all the sheets in the template and for all your Excel reports</SPAN></LI> </OL> <P>See fig 1.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fig 1" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56582iAA62037CEC7BF29A/image-size/large?v=v2&amp;px=999" role="button" title="autofill row height option.png" alt="fig 1" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">fig 1</span></span></P> <P><SPAN class="feeditemtext cxfeeditemtext">&nbsp;</SPAN></P> Thu, 10 Jun 2021 09:15:32 GMT https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Excel-Rows-are-not-automatically-resized-in-reports/ta-p/1712518 Sonja_Bauernfeind 2021-06-10T09:15:32Z