Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
chriswain2
Contributor

NPrinting Excel image sizes

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

Tags (1)
1 Solution

Accepted Solutions
chriswain2
Contributor

Re: NPrinting Excel image sizes

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.

Hidden lines.JPG

Final template:

Final template.JPGPreview.JPG

8 Replies
Partner
Partner

Re: NPrinting Excel image sizes

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.

lubicz99
Valued Contributor

Re: NPrinting Excel image sizes

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.

Excel Height.PNG

Hope that helps!

hirishv7
Honored Contributor

Re: NPrinting Excel image sizes

Hi ,

Check this,

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

HTH,

Hirish

“Aspire to Inspire before we Expire!”
Support
Support

Re: NPrinting Excel image sizes

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.

chriswain2
Contributor

Re: NPrinting Excel image sizes

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

chriswain2
Contributor

Re: NPrinting Excel image sizes

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.

chriswain2
Contributor

Re: NPrinting Excel image sizes

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.

chriswain2
Contributor

Re: NPrinting Excel image sizes

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.

Hidden lines.JPG

Final template:

Final template.JPGPreview.JPG