topic Re: NPrinting Wrapping Text in Excel in Qlik NPrinting

NPrinting Wrapping Text in Excel

Wed, 07 Oct 2015 14:44:51 GMT

I've formatted my template as wanted with 'Wrap Text' selected and certain columns coloured but when the tables are inserted when I run the task, the formatting disappears... how can I fix this???

Thanks for help in advance!

Re: NPrinting Wrapping Text in Excel

Wed, 07 Oct 2015 15:01:19 GMT

Have you de-selected "Keep source formats" in the template editor for those fields or for the entire chart?

Re: NPrinting Wrapping Text in Excel

Wed, 07 Oct 2015 15:33:47 GMT

Thanks Aran!

The text wrapping now works, but the pre-formatted colours have been overwritten with a grey (which also appears to stretch infinitely to the right), is there anything to stop that?

Re: NPrinting Wrapping Text in Excel

Wed, 07 Oct 2015 16:10:28 GMT

I'd really need to look at the template to see why the colors don't reproduce the appropriate way.

Re: NPrinting Wrapping Text in Excel

Wed, 07 Oct 2015 16:30:28 GMT

Is this any help??

This is the template:

But it appears as:

(Data removed)

Any help is much appreciated!!

Re: NPrinting Wrapping Text in Excel

Wed, 07 Oct 2015 17:41:29 GMT

You will need to bring in the charts column by column and format the individual columns with the appropriate color.

See this tutorial:

How to Create Excel Reports‌

Take a look at this section:

Embed Table Column by Column in Template Editor

Best

Aran

Re: NPrinting Wrapping Text in Excel

Thu, 08 Oct 2015 08:44:27 GMT

Thanks for your help Aran!

Is it possible to include the variables in column titles? In the original Qlikview table it appears as &vTest_Name in the column title (as we are cycling through this filter to create multiple reports). In the excel output, this doesn't transform in the excel output still appearing as &vTest_Name (when I was originally importing the whole table instead of the individual columns, this wasn't a problem!

Thanks,

Nic