topic nPrinting ######## in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829803#M5261 <HTML><HEAD></HEAD><BODY><P>In nPrinting, I have a column with a load of text appearing as #################### etc.</P><P>If I click into the cell, I can see the true text that should appear. I've tried 'wrapping text', formatting text etc and it just doesnt want to present itself correctly. Has anyone seen how to overcome this? If I make the cell 'general' from Excel formatting, it works, but once I run nPrinting again, the ##################### appears.</P><P>I've done the formatting in the template, to the QV application but cannot figure out how to get rid of the ############### and have the correct text appear.</P><P></P><P>ANy help appreciated.</P></BODY></HTML> Thu, 04 Jun 2015 13:47:12 GMT bobbydave 2015-06-04T13:47:12Z nPrinting ######## https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829803#M5261 <HTML><HEAD></HEAD><BODY><P>In nPrinting, I have a column with a load of text appearing as #################### etc.</P><P>If I click into the cell, I can see the true text that should appear. I've tried 'wrapping text', formatting text etc and it just doesnt want to present itself correctly. Has anyone seen how to overcome this? If I make the cell 'general' from Excel formatting, it works, but once I run nPrinting again, the ##################### appears.</P><P>I've done the formatting in the template, to the QV application but cannot figure out how to get rid of the ############### and have the correct text appear.</P><P></P><P>ANy help appreciated.</P></BODY></HTML> Thu, 04 Jun 2015 13:47:12 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829803#M5261 bobbydave 2015-06-04T13:47:12Z Re: nPrinting ######## https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829804#M5262 <HTML><HEAD></HEAD><BODY><P>Hi BobbyDave,</P><P></P><P>Is your column wide enough to display the text what should be there ? </P></BODY></HTML> Thu, 04 Jun 2015 15:40:27 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829804#M5262 2015-06-04T15:40:27Z Re: nPrinting ######## https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829805#M5263 <HTML><HEAD></HEAD><BODY><P>No, its not that. When the report is run, if I right click on the cell, and format the cell, I can change it from Text to General and the text will then appear as it should. Other cells will display the correct text whereas other cells might display ###################. If I hover over the&nbsp; ####################, I can see the text in a pop up tip.</P></BODY></HTML> Fri, 05 Jun 2015 08:59:34 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829805#M5263 bobbydave 2015-06-05T08:59:34Z Re: nPrinting ######## https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829806#M5264 <HTML><HEAD></HEAD><BODY><P>Does your text have any trailing spaces?</P><P>Can you trim the text in the QlikView app that is being used by NPrinting?</P></BODY></HTML> Fri, 05 Jun 2015 09:12:27 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829806#M5264 Colin-Albert 2015-06-05T09:12:27Z Re: nPrinting ######## https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829807#M5265 <HTML><HEAD></HEAD><BODY><P>Hi BobbyDave,</P><P></P><P>funnily enough I ran into the same issue a few days ago just using a standard QlikView Export to Excel. Like you, I resolved it by setting the text format to General.</P><P></P><P>I haven't had the opportunity yet to test with NPrinting. I'd suggest though that you maybe try unsetting the 'Keep Source Formats' option, and explicitly setting the text format to General in your template. Maybe this setting will be retained when the report is run.</P><P></P><P>Marcus</P></BODY></HTML> Fri, 05 Jun 2015 09:49:23 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829807#M5265 marcus_malinow 2015-06-05T09:49:23Z Re: nPrinting ######## https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829808#M5266 <HTML><HEAD></HEAD><BODY><P>The way I got around it is, once written in powerpoint, excel etc, I printed to PDF.</P><P>Straight away, the text then came out as should be.</P><P></P><P>Still hasn't resolved the Excel issue, but sending it to Print -&gt;PDF resolves the issue</P></BODY></HTML> Tue, 09 Jun 2015 11:03:40 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting/m-p/829808#M5266 bobbydave 2015-06-09T11:03:40Z