Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Excel Template Rows are shifting down.. help

Hi,

I am trying to insert a qlikview chart into an existing excel template.  Each week I need to overwrite three columns, but when I preview the Nprint template it has shifted the whole spreadsheet down.

This is the original template. On a daily basis I need to insert and overwrite the cells in O10, P10 & Q10

nprint_temp1.jpg

However, when I try and place the straight table 'cells' into the template this happens :

nprint_temp2.jpg

the  rows are shifting down which is incorrect.

Can anyone help on this?

Many thanks!

Tags (1)
1 Reply
Not applicable

Re: Excel Template Rows are shifting down.. help

Hi,  I have found the solution to my issue :

I needed to uncheck the 'Expand Range' check box in the Properties section :

nprint_properties.PNG

Community Browser