topic Re: Dates field alignment in excel in Application Development and Automation Discussions

Dates field alignment in excel

Former Member — Wed, 30 Mar 2016 11:46:42 GMT

HI experts,

I have a field bill plan date FPLT-AFDAT in my report. when I download it to excel the dates are right justified in the excel which is OK, but for some of the line items if there is no bill plan , then this field remains initial. In that case, in excel the dates(00/00/0000) are coming in left justified .

I want for both the cases either the dates are initial/not initial , the dates should have same right justification.

Please advise.

Thanks,

shadab.

Re: Dates field alignment in excel

Former Member — Wed, 30 Mar 2016 12:48:31 GMT

Hi Shadab,

How you are downloading to excel?

Through ALV or using some standard function modules?

Regards,

Srikanth.

Re: Dates field alignment in excel

Former Member — Wed, 30 Mar 2016 13:11:45 GMT

Through standard function module.

I have a custom button on my grid... On click of which I call a standard fm and download to excel

Re: Dates field alignment in excel

Former Member — Thu, 31 Mar 2016 04:39:19 GMT

You mean you add a button on your ALV tool bar to download as excel and calling some function module like 'WS_DOWNLOAD'.

If that is the case why don't you try adding export button to you ALV grid?

Regards,

Srikanth.

Re: Dates field alignment in excel

Former Member — Thu, 31 Mar 2016 08:09:11 GMT

Sorry my bad, this is a classical report, not alv. here on the application toolbar we have put one button called 'Download' on click of which FM 'GUI_DOWNLOAD'...downloads it to excel.