topic Re: Cell reference is changing after report generation in Qlik NPrinting

Cell reference is changing after report generation

btaccent — Thu, 14 Dec 2023 13:29:05 GMT

Hi There,

I have a requirement to pull a single value from a sheet in excel template to another sheet.
We use nprinting 17.

In the report editor I reference a cell in another sheet, but it is changing. Not sure why? In the below example you can see I4 is changed to I5

eg-

from- ='Sheet2'!I4

to- ='Sheet2'!I5

Please note that in the excel template I4 value only populated when report is run, till then it is empty.

Please help

Re: Cell reference is changing after report generation

Frank_S — Thu, 14 Dec 2023 16:32:52 GMT

The references are going to change when the report output is produced.

That is likely what is happening but we have little information here from you how you have constructed the report.

We also don't have the expected results nor any actual results.

Share a video or a series of snapshots along with a detailed step by step explanation of all the above.

Further more, you are extremely out of support by running NP 17.1. I am surprised it is working at all to be honest.

I suggest that you reach out to your Qlik Account manager or Partner to arrange professional services to assist you with upgrading your environment.

But since you are so deep in missing so many updates, I would suggest at this point that you install the latest version of NPrinting and basically start over.
This will be a lot easier than upgrading as you cannot upgrade directly from 17.1 to the current version of NPrinting.

QlikView May 2023 Compatibility with NPrinting - Qlik Community - 2076472

Deploying

Kind regards...

Re: Cell reference is changing after report generation

btaccent — Thu, 14 Dec 2023 17:10:21 GMT

Thanks for the information.

I have double checked and seems we use below version. Hope it is not an outdated one. Can you please let me know what is the latest stable version. Thanks.

Qlik NPrinting May 2021 SR3
Version: 21.14.7.0

Re: Cell reference is changing after report generation

Frank_S — Thu, 14 Dec 2023 17:24:09 GMT

I have shared that with you above

See the Deploying , planning and installation links.

Further, May 2023 SR 2 is also available for the above May 2023 NP track

Qlik NPrinting® Release notes - May 2023 Service R... - Qlik Community - 2117802

Kind regards...

Re: Cell reference is changing after report generation

btaccent — Mon, 18 Dec 2023 09:43:29 GMT

The issue is fixed after disabling the property 'Expand Range' for the table in nprinting.