Skip to Content
author's profile photo Former Member
Former Member

Leading 0 while downloading to excel

Hi All,

I am displaying my output in ALV using REUSE_ALV_GRID_DISPLAY,but when i download the report to excel using standard download button in the tool bar(local file icon), the leading zeros are getting truncated

eg 0004 is displayed as 4

field is VBKD-ZTERM....

Whats the way out?

<REMOVED BY MODERATOR>

Regards

Gunjan

Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:52 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2008 at 10:53 AM

    change the columns in excel sheet .. I mean format the cells to

    TEXT ...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2008 at 11:05 AM

    Hi,

    The problem might be may be because u would have opened the file using excel.

    try opening the file using notepad or else use the Function module CONVERSION_EXIT_ALPHA_OUTPUT for that field.

    <REMOVED BY MODERATOR>

    Regards

    Rose

    Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:53 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2008 at 11:06 AM

    1.Introduce another field in internal table of type Numeric.

    2.Before you pass the internal table to Reuse_alv_grid Display

    3.Move the character field to Numeric type and use this

    numeric field to display in Reuse_alv_grid_display.

    Then the leading zeros will also be displayed while downloading to Excel.

    <REMOVED BY MODERATOR>

    Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:53 PM

    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.