Text wrap doesn't work on dynamic table in Nprinting februari 2021

[MartW]

Hello,

In N-printing version februari 2021 I’m building a report (word version) that consists of a qlik sense table that is dynamically created (via show/hide conditions and buttons).

In N-printing I got the table to show up with the desired columns and all, but the outlining is terrible.

In N-printing itself we got the options to turn on/ off text wrap but both I’ve tried and both options give me back the same table with the same terrible outline.

I know that in Nprinting there still is a bug/feature request that individual columns in show/hide tables don’t show (also please fix).

Furthermore, In the Qlik Sense app that the table is used I’ve done multiple thing but also those didn’t work:

1. Changed the spacing for some fields so that text wrapping (in QS app) is not necessary.
2. In N-printing changed the text hight from standard 11 to 8. (Found a bug that only the first row was set in that text hight and the rest of the table went back to 11)
3. Did the same but changed the text hight in Qlik Sense instead of word.

Qlik Sense version:

• February 2021

N-printing version:

• February 2021

Options I cannot change:

• Upgrade N-printing to latest version
• Upgrade Qlik Sense to latest version

Issue I got:

N-printing template:

Output:

What I expect is that Title2 is not textwraped because of the text wrap options is de-selected (off) but I always get title2 text wraped.

[Lech_Miszkiewicz · Accepted solution]

Hi @MartW 

I understand your problem and I agree it is not nice to have text wrapped like that. On contrary I dont believe word setting is active to allow for fixed row height and at the same time the best option you have is to use "auto-fit contents". In MsWord table settings there is no way to set cell height while cell wrapping is switched off - that option is greyed out meaning that style feature cannot be set. Yes - you can set height and width of columns you already have, but that is different to style settings. That means you dont have much control over the wrapping anyway in MsWord. 

2.  Indeed outlining will be terrible as you never know if you will have one, two or maybe 20 columns in your report. NPrinting is template based reporting tool and dynamic tables are somehow opposite of that, so yeah this will be a problem regardless

3. Regarding your comment: there still is a bug/feature request that individual columns in show/hide tables don’t show (also please fix) - well, it is not a bug. It is working as designed and it will not be implemented for the same reasons. NPrinting is template based and dynamic hide/show for columns goes against that idea - what you currently have is the best you will have meaning that only whole table tag can be used in this instance - sorry. 

4. You are not using "Keep source format" so any changes in Qlik Sense will not be taken into account anyway and to be honest I cannot test that now to give you 100% correct answer in that regards. I know that QlikView cell widths and formats were captured nicely however Qlik Sense ones were quite fluid in that regard

5. That leaves you only with native MsWord style settings. Note that changing the individual row height or width will only have effect on that single row so you cannot do much about that. 

6. Why is this a word based template given that it has dynamic table which may/may not fit on single page. Would different template style be accepetable?

[MartW]

@Lech_Miszkiewicz , thx for the reply. I've manage to fix this thx to the post. 🙂

for point 3. I wasn't aware of this. I read the release notes and saw this in there

https://community.qlik.com/t5/Official-Support-Articles/Qlik-NPrinting-Known-Issues-and-Limitations/... (page 13)

I (and i think I not alone) think/taught that this is a bug and were hoping that it was fixed.

with regards of point 4 I tested this with both the checkbox on and off for "Keep source formatting" both didn't work. but now It works, it could also be that MS Word might overwrite this?

6. the customer I work on this project wanted this to be in a word format. I coundn't convince to go to Excel or anything. the table is part of a larger report containing lot's of QS objects.

once again. changing the table layout in MSword did the trick 

[Lech_Miszkiewicz]

Hi @MartW,

that is good news that it somewhat helped you. regarding this: with regards of point 4 I tested this with both the checkbox on and off for "Keep source formatting" both didn't work. but now It works, it could also be that MS Word might overwrite this?

yes, indeed - as I tried to explain before some things are part of the MSWord settings which NPrinting does not have control over and table style is one of such things. That means we cannot really do anything about it.