NPrinting Wrapping Text in Excel

[#1]

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!

[#2]

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

[#3]

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?

[#4]

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

[#5]

Is this any help??

This is the template:

But it appears as:

(Data removed)

Any help is much appreciated!!

[#6 · Accepted solution]

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

[#7]

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