topic Alignment in Application Development and Automation Discussions

Alignment

Former Member — Wed, 30 Apr 2008 06:56:24 GMT

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.

Re: Alignment

Former Member — Wed, 30 Apr 2008 07:03:32 GMT

write a left-alignment.

Re: Alignment

Former Member — Wed, 30 Apr 2008 07:03:40 GMT

When creating fieldcatalog for these fields ...

assign

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

Re: Alignment

Former Member — Wed, 30 Apr 2008 07:05:07 GMT

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

Re: Alignment

Former Member — Wed, 30 Apr 2008 07:18:35 GMT

Hi ,

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

Regards

Lalit