Re: Excel Print Area Error - Qlik Community

KHSDM · ‎2020-07-22

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?

Ruggero_Piccoli · ‎2020-07-22

Hi,

Please post the Scheduler and the Engine logs. Thanks.

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

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

KHSDM · ‎2020-07-30

hi,

Ok, will contact the support.

Lech_Miszkiewicz · ‎2020-07-30

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Dataman · ‎2020-09-01

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.

Lech_Miszkiewicz · ‎2020-09-02

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Ruggero_Piccoli · ‎2020-09-02

Hi,

I'm investigating here.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Ruggero_Piccoli · ‎2020-09-03

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Arthur_Marseuti · ‎2020-10-19

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

Lech_Miszkiewicz · ‎2020-10-21

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Excel Print Area Error

Qlik NPrinting June 2020

QlikView