topic Re: Excel Report has Grayness in it in Qlik NPrinting

Excel Report has Grayness in it

JustinDallas — Fri, 23 Mar 2018 16:09:23 GMT

Hello Folks,

I've got an Excel report, and for some reason, these two columns always come out gray (Minutes Late and Order). Of course, there is no gray in my template's columns whatsoever.

OUTPUT:

TEMPLATE:

Does anyone know why this could be happening and how to prevent it?

Re: Excel Report has Grayness in it

Lech_Miszkiewicz — Sun, 25 Mar 2018 23:41:26 GMT

Hi Justin,

Do you have "Keep the source format" selected in NPrinting for those columns.? Go to NPrinting designer, select from Left Nav the table you are using to pull values and inspect properties of a table as well as all fields.

regards

Lech

Re: Excel Report has Grayness in it

JustinDallas — Mon, 26 Mar 2018 13:32:46 GMT

Hello Lech,

Yep, I've got "Keep Source Formats" checked for the columns in question

Re: Excel Report has Grayness in it

Lech_Miszkiewicz — Mon, 26 Mar 2018 13:36:16 GMT

‌so you know the reason why it changes to source format. UNcheck it and it will inherit format you have setup in excel

Re: Excel Report has Grayness in it

JustinDallas — Mon, 26 Mar 2018 13:42:03 GMT

WHOOPS! I thought "Keep Source Formats" meant to apply the Excel format that I've got set up. Looks like I've got some reading to do.

Re: Excel Report has Grayness in it

Lech_Miszkiewicz — Mon, 26 Mar 2018 13:44:07 GMT

‌it is other way around. It KEEPS SOURCE FORMAT from qlik