Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sreekanth101
Contributor II
Contributor II

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
Partner

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

sreekanth101
Contributor II
Contributor II
Author

Thank you it worked!!

sreekanth101
Contributor II
Contributor II
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.