Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Material text is coming in two lines when exporting to excel from ALV

0 Kudos
213

Hello All,

Greetings !!!

1. When downloading report output from ALV in excel, half of the material text is coming in next line. As per below screen shot:

2.  Also even though I have passed column width optimise pragmatically, then also for the same report in quality server column width are fully optimised       whereas in production server, User manually need to drag the column till the text end.

My doubt is 1st issue is coming because of 2nd issue.

Please Advise how to approach.

Thanks in Advance.

1 ACCEPTED SOLUTION

former_member196331
Active Contributor
0 Kudos
168

May i know how you are downloading the file.

Right click on the report and Save

else.

By clicking on the Local field icon pressing.

Check with two ways and update me the result.

8 REPLIES 8

former_member196331
Active Contributor
0 Kudos
169

May i know how you are downloading the file.

Right click on the report and Save

else.

By clicking on the Local field icon pressing.

Check with two ways and update me the result.

0 Kudos
168

Hello NewB

Earlier I was downloading with local field option, Now I tried with right click. With Right click option, it is coming correct.

But what if  I have list display where right click does not work.

Why I am asking this because, for those material text mentioned in query, even from se11, half of text is coming in next line.


Please advise.

Former Member
0 Kudos
168

Hi Anand,

You can explicitly set the column width at the time of creation of field-catlog.

maximum you can go is till 128 characters.

For eg.

IF p_fldname = 'PROJK'.

     l_wa_fieldcat-convexit    = 'ABPSP'.

     l_wa_fieldcat-domname     = 'PS_POSNR'.

     l_wa_fieldcat-dd_outlen   = 24.

    ENDIF.

Regards

Kishan

0 Kudos
168

Hello Krishna,

Tried this option already by increasing the output length in debugger, Not working.

Any other solution,

Thanks,

rosenberg_eitan
Active Contributor
0 Kudos
168

Hi,

Are you downloading using CSV ?

Please post a screen shot of your internal table content (debug) .

Regards.

Eitan.

0 Kudos
168

Hello Eitan,

Downloading simply by 'Local File....' feature available in ALV.

Thanks,

0 Kudos
168

Hello ,

Try to open the file created with text editor(Notepad++ Home).

Check if you have CR LF etc.

Regards.

0 Kudos
168

Hello Experts,

Any solution or work around, Please reply.

Thanks,