Wrap text issue when exported to Excel

[Anonymous]

Hi,

I am trying to figure out a way to retain the wrap text formatting that I have in one of my charts when I export to Excel. When I send to Excel the wrap text format is gone.

My expression in the chart is like:

Dim_1&chr(13)&Dim_2

Dim_1 and Dim_2 are two fields in the datamodel and I need to have them in separate lines. I am able to accomplish this in QlikView chart with the Expression and checking the Multiline option in the Presentation tab.

But when I export to Excel the wrap text format is gone.

Is Macro the only way. If yes, can anyone help me with the Macro.

Thanks,

Srikanth

[Miguel_Angel_Baeyens]

In the resulting Excel file, click on the row and then "Wrap text", unless wrapping is already enabled (if such thing is even possible I don't know).

Use Chr(10) & Chr(13) if the chart is used in both web view and ready to export.

[uacg0009]

Hi Srikanth,

I found a way, but you need to click a button in excel after you export...I don't know whether there is a better way...

Firstly you need to use chr(10) not chr(13)

And then after you export to excel, you need to choose the corresponding column, and click below button in red circle in excel:

Sorry it's Chinese system, the button means Auto Wrap.

You can have a try.

Thanks.

Aiolos

[Anonymous]

Thank you it worked!!

[Anonymous]

Thank you Miguel!!

So should my expression be like

Dim_1&chr(10)&chr(13)&Dim_2

Thanks,

Srikanth

[Miguel_Angel_Baeyens]

Yes, exactly. Still, you need to enable the wrap text on Excel.