Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Wrap text issue when exported to Excel

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

5 Replies
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
Partner - Specialist
Partner - Specialist

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:

Wrap text issue when exported to Excel.PNG

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


You can have a try.


Thanks.

Aiolos

Anonymous
Not applicable
Author

Thank you it worked!!

Anonymous
Not applicable
Author

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.