
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excel Print Area Error
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?
- Tags:
- excel
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
Ok, will contact the support.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any news on this bug? In the February 2020 version this worked fine. Updated today to September 2020 and got this nice bug.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- « Previous Replies
-
- 1
- 2
- Next Replies »