Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Decimal Notation in excel files.

Former Member
0 Likes
605

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.

2 REPLIES 2
Read only

MarcinPciak
Active Contributor
0 Likes
449

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

M.

Read only

former_member156446
Active Contributor
0 Likes
449

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