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: 

Leading 0 while downloading to excel

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

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

TEXT ...

Former Member
0 Kudos

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

Former Member
0 Kudos

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