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: 
bobbydave
Creator III
Creator III

nPrinting ########

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.

1 Solution

Accepted Solutions
marcus_malinow
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

5 Replies
Not applicable

Hi BobbyDave,

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

bobbydave
Creator III
Creator III
Author

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
Partner - Specialist III
Partner - Specialist III

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
Creator III
Creator III
Author

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