topic Re: NPrinting Excel image sizes in Qlik NPrinting

NPrinting Excel image sizes

chriswain2 — Mon, 15 Feb 2016 16:08:22 GMT

Hi,

I am creating an NPrinting excel report and when I include a chart object and set it to fit inside an area, it still inserts lines further along to the right. How can I stop this happening? I don't want to use Powerpoint as I find it much easier to lay out tables of numbers in excel.

I attach screenshots of the template and the preview.

Thanks

Re: NPrinting Excel image sizes

ajayrai — Mon, 15 Feb 2016 18:23:06 GMT

Open tool bar and set background to no fill and hide grids by un-checking the grid lines option.

It is not Nprinting issue it is excel property.

Re: NPrinting Excel image sizes

Anonymous — Mon, 15 Feb 2016 18:43:44 GMT

Chris,

I added an image to Excel and used these settings. Just pick your height and the object should size to the dimension you want. This is assuming that you have it set up proportionately in your QV app.

In this case, I adjusted the height to 300 or 3 Inches and let Nprinting automatically adjust the width based on the ratio in the qv app.

Hope that helps!

Re: NPrinting Excel image sizes

HirisH_V7 — Mon, 15 Feb 2016 18:57:29 GMT

Hi ,

Check this,

Image Dimension Management in Microsoft Office Reports – Customer Feedback for Vizubi

HTH,

Hirish

Re: NPrinting Excel image sizes

Daniel_Jenkins — Mon, 15 Feb 2016 20:51:06 GMT

Hi Chris,

This has been discussed several times in this forum. Here is one discussion: Re: Instertion of a picture with NPrinting.

In your case it looks like the Max Width is restricted to 500 and the height adjusted proportionately as expected when using the Fit Inside option.

HTH - Daniel.

Re: NPrinting Excel image sizes

chriswain2 — Mon, 15 Feb 2016 21:45:32 GMT

Thanks for all your help.I will try these ideas and let you know how I get on.

Re: NPrinting Excel image sizes

chriswain2 — Tue, 16 Feb 2016 08:20:05 GMT

Hi Ajay,

This does not work because even though the gridlines are hidden it still inserts lines into the data to the right of the image and moves the data down.

Re: NPrinting Excel image sizes

chriswain2 — Tue, 16 Feb 2016 08:28:12 GMT

Hi Mike,

It adjusts the image size fine, but I still get the problem where it inserts excel lines to do that, which causes the data to the right hand side to be shifted down. This even happens when I merge some cells which should easily contain the final image.

Re: NPrinting Excel image sizes

chriswain2 — Tue, 16 Feb 2016 09:17:38 GMT

Hi all,

I have come up with a fix, but I can't see it mentioned in any of the previous discussions. What I did was insert some lines, enough to hold the chart, then put the chart object on the last line, which is very important or it does not work when converted to html output. The object properties are set as "don't fit". Then hide the lines and preview.

Screenshots below. The image appears in the correct place, the hidden lines disappear and the data to the right does not get pushed down.

Final template:

Re: NPrinting Excel image sizes

rwb139 — Tue, 24 Nov 2020 15:01:13 GMT

Hi @chriswain2

I know this has been a while since you posted this solution but I am having a similar issue (https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Images-in-Excel-keep-adding-rows/m-p/1763379#M30570) and have tried following your advice to no avail. I was hoping you might be able to shed some more light on how you were able to solve this issue as inserting the line shapes is still not working for me. Thanks!