resize textbox in Nprinting to column widht?

[curiousfellow]

In a qlik app I created a lot of textboxes which have a conditional format.

Now I want to use these objects in Nprinting in an excel  template.

When I decrease the widht of the excel column and run a preview it looks like a piece of the textbox is cut off , so not resized.

Is there a way to decrease the column width without resizing the textbox in Qlik ?

[Chanty4u]

what ever the formatting you have to do in Excel template only. 

[devarasu07 · Accepted solution]

Hi

which version of Nprinting are u using it?

may be you can try this way (i've used Nprint 16.3 if u r using Nprint 17 try to look for similar properties and similar way it should work)

1) try to create chart object with correct width/height setting in qlikview/sense itself

2) try to import this text object as image option then you can get the desired output.

also u can do custom width/height /Stretch inside excel template

[Ruggero_Piccoli]

Refer also to Image dimension management in Microsoft Office reports ‒ Qlik NPrinting

Best,

Ruggero

[curiousfellow]

I don't want to change the textboxes in the qlik app, because it's layout is perfect to show on a computerscreen

I am using Nprinting 17. @sureshqv  Formatting in Excel is almost impossible because the formatting is conditional with some complex expression's .