topic Re: Nprinting excel template with text box in Qlik NPrinting

Nprinting excel template with text box

ronaldwang — Fri, 23 Mar 2018 02:00:04 GMT

I am using excel template where i insert table object in cell A5 and then have a pre-defined text box put in cell W5.

what i want is that when table object is populated text box should move and adjust with cell size. but the result is that the whole text box is pushed below the table. any solution for this?

Re: Nprinting excel template with text box

Lech_Miszkiewicz — Fri, 23 Mar 2018 02:12:22 GMT

Hi Ronald,

Just QQ-Is your Table object Straight or Pivot Table?

Re: Nprinting excel template with text box

Lech_Miszkiewicz — Fri, 23 Mar 2018 02:24:58 GMT

Ok Ronald - here is the thing: Text box is not an object which lives in particular cell - therefore you will not be able to enforce it to change / expand with the table. It will always keep the original size.

In terms of its original position:

What you can do is to keep it in cell W5 by unchecking "Exapnd Range" checkbox in NPrinting designer for the table tag/node.

that is all what you can do

cheers

Lech

Re: Nprinting excel template with text box

Lech_Miszkiewicz — Fri, 23 Mar 2018 02:32:58 GMT

One more option:

If you want to have merged cell accross all rows alongside table maybe instead of using textbox you can just merged cells (marked in yellow) like in screenshot 1 below with "Expand Range" checked.

Once you produce report the merged cells area expands ....

Re: Nprinting excel template with text box

ronaldwang — Fri, 23 Mar 2018 02:39:03 GMT

Thanks Lech, it is a straight table