Skip to Content
Former Member
Nov 01, 2007 at 02:35 AM

Leading spaces in excel file from ALV


Hi Guys,

once I export a record from ALV to excel. Some values I think all values that are TYPE I. How can I remove this leading spaces.

Ex: ' 100'

something like that.. so if you dont expand the column with you wont see the value 100. I checked the internal table being passed to ALV. It doesnt have leading spaces also in the ALV display. there is no leading spaces. Is there something to to with column width optimization? I need this to optimize the column headers. Thanks in Advance!


Michael Nacionales