topic Re: NPrinting May 2021 SR2 Excel issues in Qlik NPrinting

NPrinting May 2021 SR2 Excel issues

Judge_Qlik — Wed, 27 Oct 2021 02:07:08 GMT

Good day

Upgraded to NPrinting May 2021 SR2 (server, engine & designer)

When opening any Excel report via designer I get the following.

Anyone know the fix for this?

Re: NPrinting May 2021 SR2 Excel issues

Lech_Miszkiewicz — Wed, 27 Oct 2021 07:56:24 GMT

Hi,

Please search community for existing topics. This one was already discussed so many times that is hard to provide link to most recent answer:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Qlik-NPrinting-Designer-can-t-find-a-supported-template-editor/td-p/1844229

From my end here are the things I have done which worked for me despite the fact that my excel has upgraded to version which is causing issues:

1. 100% zoom settings on all screens in Windows setting--> Display-->Scale and layout

2. Excel settings set to "Optimize for best appearance":

3. NPrinting designer .exe file settings:

So it is up to you if you want to try those options or wait for Qlik to come up with more permanent solution

cheers

Re: NPrinting May 2021 SR2 Excel issues

Judge_Qlik — Wed, 27 Oct 2021 20:40:43 GMT

Hi mate

Thanks for your feedback.

I replicated the settings you suggested and it resolved the issue.

Hopefully Qlik will apply a permanent fix soon.

Kind regards

Re: NPrinting May 2021 SR2 Excel issues

DavidDocquoyBaudelet — Thu, 28 Oct 2021 07:27:51 GMT

Hi,

the proposed solution works perfectly, thank you very much !!!

Re: NPrinting May 2021 SR2 Excel issues

parkera — Fri, 29 Oct 2021 08:23:57 GMT

Hi Lech,

Thank you for sharing.

Regards

Adrian

Re: NPrinting May 2021 SR2 Excel issues

Mirham — Fri, 29 Oct 2021 09:05:03 GMT

Hi Lech,

This worked for me, Thanks a lot!

Re: NPrinting May 2021 SR2 Excel issues

wonkymeister — Fri, 29 Oct 2021 09:52:16 GMT

Thanks Lech - works for me

Re: NPrinting May 2021 SR2 Excel issues

TonyC — Fri, 29 Oct 2021 10:45:47 GMT

Thanks Lech, This worked for me too.

Frustratingly I am sure I had tried all of these in various combinations based on advice from various contributors, but this combination of all 5 settings seems to do the trick!

Let's hope the next version of Designer fixes this.

Cheers.

Re: NPrinting May 2021 SR2 Excel issues

peter_turner — Wed, 03 Nov 2021 15:41:33 GMT

Hello,

Thanks for the post, it worked for me also.
I narrowed the single setting I needed to change to

NPrintingDesigner.exe > Properties> Compatibility> Change high DPI settings> Check the box for High DPI scaling override, Scaling performed by: Application.

Re: NPrinting May 2021 SR2 Excel issues

Alan_Tilney — Thu, 04 Nov 2021 11:28:32 GMT

Thanks, worked for me too.

Re: NPrinting May 2021 SR2 Excel issues

PuriVelasco — Fri, 12 Nov 2021 09:56:01 GMT

It didn't run for me. At the begining runned after changing the screen configuration but now it has failed again...

I tried the five stepts but doesn't run althoug I have used all possibilities.

Any ideas?

Thank you very much.

Re: NPrinting May 2021 SR2 Excel issues

Judge_Qlik — Sun, 14 Nov 2021 20:43:05 GMT

Hi there

Very difficult to say what changed in your setup, maybe some windows updates that ran and reset the settings?

If you have dual screens, try and use the same screen every time for NP designer.

Hope this works for you.

Kind regards

Re: NPrinting May 2021 SR2 Excel issues

PuriVelasco — Mon, 15 Nov 2021 09:12:11 GMT

In response to Judge_Qlik

Hello,

thank you very much for your answer.

In my setup don't have had any changes. I usually work with dual screens but I have tried to work with one screen with a resolution of 100%, but didn't change anything: the issue is there.

Re: NPrinting May 2021 SR2 Excel issues

Frank_S — Mon, 15 Nov 2021 19:36:12 GMT

@PuriVelasco

Please walk through the points mentioned in the following article and post your findings in a comment at the end of it. Our R&D team is tracking that thread.

Qlik NPrinting can't find supported reporting temp... - Qlik Community - 1716228

Keep in mind that if your issue is the result of a recent planned or automated windows update to MS office, that fix is expected in the NPrinting May 2021 SR 3. Although the fix is in May 2021 SR 3 they are still performing extensive testing before releasing.

There is a blog link in the article above that will update when the Service Release will be made public.

Kind regards...

Re: NPrinting May 2021 SR2 Excel issues

PuriVelasco — Tue, 16 Nov 2021 10:54:47 GMT

Good morning,

I have walked through the points article you mentioned. I have tried with resolution screen of 100%, and with several options of Excel related with optimization for apparience or for compatibility.

I think my issue is for an Office 2019 update. (In fact I have disabled the automatic updates). My Office version is successfully installed with an account with enough privileges. I am working with Office 2019 since several months ago.

I have reinstalled Office but the results don't have changed for me.

I am working with a August 2021 Patch 3 Sense version and NPrinting May 2021 R2 version. All services run very well except this one.

Thank you very much.

Kind regards.

Re: NPrinting May 2021 SR2 Excel issues

eucastillo1 — Tue, 14 Mar 2023 20:41:56 GMT

thank you so much, it works!!!!

Re: NPrinting May 2021 SR2 Excel issues

priyanka08 — Tue, 25 Apr 2023 03:11:47 GMT

it doent works for me .Get same error even after Implementing the changes