Solved: Re: NPrinting Excel missing borders - Qlik Community

markiskander · ‎2022-10-20

We have an NPrinting report / Excel template for which the Grid Lines / Borders are not carrying down through each line of the levels. Does anyone know what might be causing this, or know of a workaround?

Below is a screenshot of the Template and of the resulting spreadsheet. you can see the break in the border between columns A and B, D and E, G and H, etc. in between the light blue rows. I've tried with and without the <delete row> as well as extra blank lines, but still get the same result.

We're on QlikSenseServer 14.54.2, and NPrinting Version 21.14.7.0

Thanks!

Here's how the report looks when it's generated (and the template is below):ResultTemplate

Frank_S · ‎2022-10-21

Try this:

Deselect the 'keep source formats' check box on the top chart object. Allow the 'keep source formats; changes to be applied to each individual field.
Place your boarder as needed using Microsoft Excel boarder tool
Ensure that the column width is sufficient ie: use only 2 decimal points for example and resize the column with accordingly
Preview

Example and image attached containing results.

Hope this helps...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

Frank_S · ‎2022-10-21

Try this:

Deselect the 'keep source formats' check box on the top chart object. Allow the 'keep source formats; changes to be applied to each individual field.
Place your boarder as needed using Microsoft Excel boarder tool
Ensure that the column width is sufficient ie: use only 2 decimal points for example and resize the column with accordingly
Preview

Example and image attached containing results.

Hope this helps...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

markiskander · ‎2022-10-21

That did it - THANK YOU!

Frank_S · ‎2022-10-21

Great news!

Thanks for sharing.
I've move your post to the Qlik NPrinting Community as well in case others have the same question and can benefit from the solution provided.

NP Community

Cheers!

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Ruggero_Piccoli · ‎2022-10-24

Hi,

Qlik NPrinting 21.14.7 is May 2021 SR3. Thanks for adding the details of the version in the text but, please, remember also to add the label that will be easier to find. Thanks.

I also suggest you upgrade your installation to a more recent version because we solved some issues with borders associated with merged cells and it could be that you are experiencing one of them. May 2022 IR solves this:

Borders were randomly added to merged cells
Jira issue ID: OP-95639
Borders were sometimes added to some merged cells of generated reports, even if they were not set in the
source template.

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.

NPrinting Excel missing borders

General Question