field alignment

[Former Member]

Dear friends

I have a Alv grid report, after running the report i am downloading the file to excel sheet by local download method. after downloading to excel sheet one field(Currency field) is center aligned.

I need to make the field left alligned, Pls suggest me how to make this.

thanks in advance

karthik

[Former Member]

If you want to do it manulay, then select that column in excel and click on the Left Alignment button in the toolbar

If you want to do it in program , then in fieldcatalog ,

wa_fieldcat-fieldname = 'CUUR_FIELD'.
wa_fieldcat-just = 'L'.

Message was edited by:

Chandrasekhar Jagarlamudi

[sreeramkumar_madisetty]

Hi

At the time of creation of the report itself you have to do this.

Default all are left aligned only.

Regards,

Sreeram

[Former Member]

If you want to do it manulay, then select that column in excel and click on the Left Alignment button in the toolbar

If you want to do it in program , then in fieldcatalog ,

wa_fieldcat-fieldname = 'CUUR_FIELD'.
wa_fieldcat-just = 'L'.

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

Instead of using a CUrrency type field in the itab, use a normal char type variable in the itab declaration.

Regards,

Ravi