Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

cancel
Showing results for 
Search instead for 
Did you mean: 
shanemichelon
Partner
Partner

NPrinting Cell Justification for Excel reports

Hi.  I have a situation which I think is fairly common.

I have a straight table in Qlikview and I am using it for a report in NPrinting.

The expressions are all set to right justify for text and numeric in Presentation.

In the expression, I have it displaying text if there is no data:

  =if(Sum(Amount)=0,'No Sales',Sum(Amount))

When I use this is NPrinting for an excel report, the numeric cells are right justified, but the text cells are left justified.

NPrinting Justification Issue.png

Any idea on how to fix this?

14 Replies
avinashelite

its the default nature of excel , we don't have any control on that.

morganaaron
Specialist
Specialist

I'm passing the item to nPrinting and selecting 'keep source format' - which it's not doing. You can tell excel how to align things, including labels, so to me this is an error/bug and so I disagree, we should have control over that.

neha_sri
Creator III
Creator III

Hi Shane/Aaron,

Did you get any solution to this. I am facing the same issue.

Regards

phirangi91
Contributor III
Contributor III

Did you get it solved??

I'm stuck with same issue any help is appreciated.

boyan-kukov
Contributor II
Contributor II

This can be fixed by ignoring the source code in the properties tab for the individual tables. It'll ignore that it identifies it as a character and your report will be centered.