Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Thank you it worked!!
Thank you Miguel!!
So should my expression be like
Dim_1&chr(10)&chr(13)&Dim_2
Thanks,
Srikanth
Yes, exactly. Still, you need to enable the wrap text on Excel.