nPrinting ########

[bobbydave]

In nPrinting, I have a column with a load of text appearing as #################### etc.

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.

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.

ANy help appreciated.

[#2]

Hi BobbyDave,

Is your column wide enough to display the text what should be there ?

[bobbydave]

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  ####################, I can see the text in a pop up tip.

[Colin-Albert]

Does your text have any trailing spaces?

Can you trim the text in the QlikView app that is being used by NPrinting?

[marcus_malinow · Accepted solution]

Hi BobbyDave,

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.

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.

Marcus

[bobbydave]

The way I got around it is, once written in powerpoint, excel etc, I printed to PDF.

Straight away, the text then came out as should be.

Still hasn't resolved the Excel issue, but sending it to Print ->PDF resolves the issue