topic Re: Images in Excel keep adding rows in Qlik NPrinting

Images in Excel keep adding rows

rwb139 — Fri, 20 Nov 2020 19:47:58 GMT

Hello,

I have an issue with adding an image into my nPrinting Excel report. For whatever reason, excel keeps adding rows where my image is when I don't want it. Attached is a picture of how it is adding them. I have tried messing with the stretch, max and min heights, and the data displayed height and width with no luck. Thanks in advance for the help!

Re: Images in Excel keep adding rows

Ruggero_Piccoli — Mon, 07 Dec 2020 14:40:02 GMT

[Edited]

Hi,

Unlucky the Expand Range option doesn't exist for images so when the reports are generated the rows will be added.

I edited this replay because native Excel charts do not work inside levels at the moment (latest version is November 2020).

Best Regards,

Ruggero

Re: Images in Excel keep adding rows

rwb139 — Fri, 04 Dec 2020 19:45:48 GMT

Hi @Ruggero_Piccoli ,

I have tried following along with that but for some reason, my charts are not even appearing when I right click on levels and try to add them as the walkthrough shows.

Re: Images in Excel keep adding rows

rwb139 — Fri, 04 Dec 2020 19:50:25 GMT

@Ruggero_Piccoli

I've been able to add a chart and get my initial level working, but on the proceeding levels, it uses the same data as the first level and I'm not sure why:

Re: Images in Excel keep adding rows

Ruggero_Piccoli — Mon, 07 Dec 2020 14:52:11 GMT

Hi,

I did some tests and the only solution I found is to use images for both the table and the chart:

The result is:

Best Regards,

Ruggero

Re: Images in Excel keep adding rows

rwb139 — Mon, 07 Dec 2020 15:31:23 GMT

@Ruggero_Piccoli ,

Thanks for working on helping find a solution. I've also tried that approach to just use images. However, I can't figure out a way for nPrinting to not add in extra rows that throw everything off like in my first picture with the pie chart. Hopefully, there is an update soon that allows for this! Thanks again and please let me know if you do find a solution or workaround!

Re: Images in Excel keep adding rows

Ruggero_Piccoli — Mon, 07 Dec 2020 15:37:01 GMT

Hi,

Please evaluate to open a support ticket with a link to this conversation and, if possible, some (also scrambled) data and the template. I cannot promise nothing but this will let us to deeper investigate.

Best Regards,

Ruggero

Re: Images in Excel keep adding rows

rwb139 — Mon, 07 Dec 2020 18:18:11 GMT

Thanks for your help. Also in the meantime, is there an easy way to size my charts without having to preview them every time? I'm trying to work with the data displayed height/width and max height/width while using the stretch object. Thanks in advance!