Alignment

[Former Member]

hi all,

i have developed an ALV report,

the problem now is 2 fields local currency and document currency are right aligned ,while importing to excel , they are importing with leading spaces that need to be deleted.

so this 2 fields should aligned to left.

please help how to write code for this.

thanks in advance.

[Former Member]

write a left-alignment.

[Former Member]

When creating fieldcatalog for these fields ...

assign

JUST = 'L' .. means left justified ...

[Former Member]

Hello

This seems to be more of a problem related to Excel than SAP. In the excel speadsheet if the number is entered it will be always alligned to right and not left. To overcome this problem, basically you have make sure you are saving number as a text in excel. To achieve that while downloading to excel prefix the number with a apostrophe ( ' ), then the downloaded value will be number stored as text in excel and it will be alligned to left.

Regards

~ Ranganath

[Former Member]

Hi ,

check in the fieldcatalog there is an option for the left aligned

Regards

Lalit