topic Re: Excel Print Area Error in Qlik NPrinting

Excel Print Area Error

KHSDM — Wed, 22 Jul 2020 04:55:57 GMT

Hi,

Recently I upgraded my Nprinting to June 2020 SR1 (from Nov 2019). But I'm having error when generating Excel report with print area. Previously before the upgrade, I don't have such problem. The reason for using the print area is because we want to exclude certain column in the PDF generated. Anyone else facing the same issue?

Re: Excel Print Area Error

Ruggero_Piccoli — Wed, 22 Jul 2020 08:32:14 GMT

Hi,

Please post the Scheduler and the Engine logs. Thanks.

If you cannot post them here, please open a support ticket.

Best Regards,

Ruggero

Re: Excel Print Area Error

KHSDM — Thu, 30 Jul 2020 06:00:51 GMT

hi,

Ok, will contact the support.

Re: Excel Print Area Error

Lech_Miszkiewicz — Thu, 30 Jul 2020 07:28:08 GMT

Hi @Ruggero_Piccoli & @KHSDM

One of my clients experienced the same. Resetting Print area by editing report, removing and setting up print area from scratch solved the problem. I have experienced this on upgrade from Feb 2020 to June 2020 Patch 1

Re: Excel Print Area Error

Dataman — Tue, 01 Sep 2020 21:06:29 GMT

Hi @Lech_Miszkiewicz

I had the same issue but only removing the print area permanently solves the problem. Could you describe the steps how to set up a new print area without getting the error message?

Thanks.

Re: Excel Print Area Error

Lech_Miszkiewicz — Wed, 02 Sep 2020 08:59:12 GMT

Hi @Dataman

it was quite straight forward process. I had to go through every sheet (note that you may also have hidden sheets) and do following:

click on Page Layout
click Print Area - > Clear Print Area
select cells/columns for Print Area
click Set Print Area
use Width:, Height: Scale options as per your needs - in my case it is usually 1 page width and height automatic, 100% scale

that was it.

regards L.

Re: Excel Print Area Error

Ruggero_Piccoli — Wed, 02 Sep 2020 12:42:26 GMT

Hi,

I'm investigating here.

Best Regards,

Ruggero

Re: Excel Print Area Error

Ruggero_Piccoli — Thu, 03 Sep 2020 09:32:42 GMT

Hi,

We need to check the templates. We suggest you to open a support ticket with everything is necessary to reproduce the issue. So templates, data, steps, etc.

Best Regards,

Ruggero

Re: Excel Print Area Error

Arthur_Marseuti — Mon, 19 Oct 2020 16:14:33 GMT

Any news on this bug? In the February 2020 version this worked fine. Updated today to September 2020 and got this nice bug.

Re: Excel Print Area Error

Lech_Miszkiewicz — Wed, 21 Oct 2020 22:50:29 GMT

I had the same issue here when migrating from April to September 2020 and had to re-do one report which had print area set

Re: Excel Print Area Error

Ruggero_Piccoli — Thu, 22 Oct 2020 10:01:54 GMT

Hi @Lech_Miszkiewicz ,

I suppose that re-create only the printing area could solve. Did you tested it?

Best Regards,

Ruggero

Re: Excel Print Area Error

Lech_Miszkiewicz — Thu, 22 Oct 2020 10:38:59 GMT

Hi @Ruggero_Piccoli

correct. I had to recreate print area only

Re: Excel Print Area Error

Archie — Fri, 05 Mar 2021 11:03:03 GMT

Hi,

In my environment (Nprinting 2020 Nov + Qlik Sense Enterprise 2020 Nov) the error persisted even after clearing and recreating the print area. Only removing the print area completely, solved the error. So looks like the bug is not yet fixed completely.

Re: Excel Print Area Error

Ruggero_Piccoli — Fri, 05 Mar 2021 11:24:07 GMT

Hi,

February 2021 has the following bug fix:

Excel print area with more than one range
The creation of Excel reports with worksheets containing print areas with more than one range ended with the
error: “Invalid Cell Name”. Thanks to this bugfix, you can create print areas with more than one range, but that
print area must not be modified during report creation.

Maybe it is your case.

Best Regards,

Ruggero