Skip to Content

ALV download to local file, splits line in two

Dear Abapers,

I have a quite wide ALV report, when downloading to local file, I get the "long" line splitted in 2 (in case of spreadsheet format) and in 3 in case of unconverted format.

Is there a turn arround in order to have only one line?

It's not an excel limitation, once there are enough columns to paste the "lower" part of the line on the right of the "upper" part.

Thanks in advance.

FLP

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Feb 25, 2009 at 05:22 PM

    How you are downloading into excel?

    Try to use " Excel in place" functionality of alv grid. it will open up in excel with single line.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2009 at 07:47 AM

    Hi,

    I download the report, pressing the "Local File... (CtrlShiftF9) icon on the ALV, after I choose "Uncoverted" or "Spreadsheet" radio button. If by "Excel in place" you mean press the "Microsoft Excel" icon, for some stransge reason, on my pc and some other users this doesn works, nothing happens or a blank spreadsheet is opened, if you mean something else, plese revert, once I didn't understand it correctly.

    Thanks in advanve

    FLP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 08:47 AM

    Hi,

    For activating Excel button on ALV do the following

    Open Excel & change the macro security by going to

    Tools->Macro->Security and on the security level tab choose medium radio button.

    After this your Excel will show the contents of you report.

    anya

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2009 at 09:48 AM

    Hi,

    That didn't work, in fact the security level was on "low".

    Still, via the normal download button, is there a way of not having the downloaded file splited in two lines?

    Thanks in advance.

    FLP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 09:58 AM

    Hi

    Good,

    If you are saving it in .txt format than remove the word wrap from your text file ,if you are saving it into the excel sheet than it would work fine.

    Thanks

    mrutyun^

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2009 at 10:43 AM

    Hi,

    Sorry, doesn't works like that.

    In txt format, even with the wrap switched off, on character 1023 the line breaks into a new line. The report is 1111 chars wide.

    On excel format is the same thing.

    Is there a limit on excel/txt/ALV or can this be turn arround?

    Thanks in advance.

    FLP

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.