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?
Accepted Solutions
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
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
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 ....
