topic Decimal Notation in excel files. in Application Development and Automation Discussions

Decimal Notation in excel files.

Former Member — Tue, 25 Nov 2008 12:39:24 GMT

Hi,

Requirement is to have the decimal notation in the user specific setting in the downloaded excel file.

Whatever format is chosen by the user (tcode su01), must appear in excel file.

I have tried with using SET COUNTRY right before the fn call GUI_DOWNLOAD, but it doesn't work.

Please suggest a relevant solution.

Thanks.

MarcinPciak — Tue, 25 Nov 2008 13:04:00 GMT

Try this logic:


data: amount_p type p decimals 2 value '12345.67',
        amount_c(12) type c.

write amount_p to amount_c DDMMYY.
write amount_c.

Now amount_c is with the decimal format of the user.

Do the same for the amount fields in your table and then pass it to GUI_DOWNLOAD.

Regards

former_member156446 — Tue, 25 Nov 2008 14:11:12 GMT

Hi you got to send the numeric field into character fields types.. and then send to gui_download....