topic Re: Excel - merged cells in Qlik NPrinting

Excel - merged cells

Srpic — Mon, 01 Nov 2021 14:24:20 GMT

Hi there,

I need to create an excel file, which creates a table with merge cells like on the below picture:

I unchecked Keep Source Format and it works fine, but only for the very first row, other rows are not merged. Any ideas how to achieve this? So that the format is expanded across all rows and not just the very first one, please?

Thanks you!

Re: Excel - merged cells

Frank_S — Mon, 01 Nov 2021 16:28:16 GMT

@Srpic

Please confirm if you are or are not using NPrinting 17.0. You selected NP 17.0 when starting this discussion.

If so which version of NPrinting Server and Designer are you using?

Our answer will depend on your response.

Kind regards...

Re: Excel - merged cells

Frank_S — Mon, 01 Nov 2021 16:34:50 GMT

ote that I have tested with May 2021 NPrinting and do not have the issue you reported.

All rows and merged columns take the background fill format with keep source format checkbox removed from the table and individual objects.

You can see this in the image of the output below:

Re: Excel - merged cells

Lech_Miszkiewicz — Mon, 01 Nov 2021 21:56:02 GMT

Key information here is a version you are using. Merged cells were introduced only in May 2021 SR1 version and this is documented in release notes:

Merged cells in columns and cells are supported Jira issue ID: OP-9315 OP-9812 Columns or cells inserted into merge cells now retain the merged status and will be produced as merged cells in generated reports.

If you are using earlier version of NPrinting this will not work.

Re: Excel - merged cells

Srpic — Tue, 02 Nov 2021 04:35:10 GMT

Thanks @Frank_S . That's the reason, I guess. I was wrong about the version - it is November 2019 (Version: 19.40.3.0), hence the merged cells are not possible, I guess.

Re: Excel - merged cells

Srpic — Tue, 02 Nov 2021 04:36:11 GMT

Thanks @Lech_Miszkiewicz , unfortunately, I'm using November 2019 version, hence it's not possible then.

Re: Excel - merged cells

Richard4 — Tue, 02 Nov 2021 19:07:35 GMT

Hi @Frank_S ,

I have the same problem as Srpic, but I have the MAY 2021 Versión: 21.14.3.0 and I have tried to remove the "Keep source formats" option and continue without having the expected result.
Sorry for my ignorance, but is my version different from the SR1 you mentioned in your previous answer?

Thank you very much!

Re: Excel - merged cells

Frank_S — Tue, 02 Nov 2021 19:33:44 GMT

I'll need to imitate your environment @Richard4 as you appear to have a few calculated columns.

My test environment only contains simple dimension values. I'll need to create calculated columns in my test app.

In the meantime perhaps you could try move your calculated columns to the load script, reload the NP connection and retest.

Kind regards...

Re: Excel - merged cells

Richard4 — Tue, 02 Nov 2021 20:29:04 GMT

Thank you very much @Frank_S ,

I have tried with simple values and I get the same result.

Re: Excel - merged cells

Frank_S — Tue, 02 Nov 2021 20:41:49 GMT

Ok thanks!

Please explain your:

Expected results

Actual Results

date values?
Are the columns becoming unmerged?
other unexpected output

If the latter, try these steps
1. Drag each NP dimension tags to the template editor separately (this will also bring over the column titles

2. Select the tag cell and the cell to the left or right of it ie BC DE etc (ignore the title cells for now)

3. Merge the two cells

4. Preview the report.

Don't type the NP tag into the merged cell.

Thanks...

Re: Excel - merged cells

Lech_Miszkiewicz — Tue, 02 Nov 2021 21:01:23 GMT

Hi @Richard4

Your version is Initital Release (so yeah - it is different) and does not have merged cells feature. Your version is the last which does not support merged cells.

You will have to upgrade to at least SR1. @Frank_S - no need to test this, it is not supported in version Richard is using.

Re: Excel - merged cells

Richard4 — Tue, 02 Nov 2021 21:40:30 GMT

Hello @Lech_Miszkiewicz

I really appreciate your answer and that image is very useful to me.

I thank you @Lech_Miszkiewicz , @Frank_S for the time you took to help me.
Hope you guys have an excellent week.

Hugs!