topic Re: NPrinting Excel missing borders in Qlik NPrinting

NPrinting Excel missing borders

markiskander — Thu, 20 Oct 2022 12:14:49 GMT

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

Re: NPrinting Excel missing borders

Frank_S — Fri, 21 Oct 2022 14:48:01 GMT

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...

Re: NPrinting Excel missing borders

markiskander — Fri, 21 Oct 2022 16:44:55 GMT

That did it - THANK YOU!

Re: NPrinting Excel missing borders

Frank_S — Fri, 21 Oct 2022 17:38:39 GMT

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!

Re: NPrinting Excel missing borders

Ruggero_Piccoli — Mon, 24 Oct 2022 09:30:13 GMT

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