topic Decimal notation problem when downloading in Application Development and Automation Discussions

Decimal notation problem when downloading

Former Member — Thu, 30 Oct 2008 11:10:35 GMT

Hi,

I hava report wich downloads the data to excel file. The decimal notation for data is for gemna. ( COmma instead of dot and dot instead of comma). I have changed in user profile also. But when downloading to excel its downloading in default decimal notation. which is opposite format.

This should be for all quantity fields

Thanks

Kishore B A

Re: Decimal notation problem when downloading

Former Member — Thu, 30 Oct 2008 11:13:08 GMT

Hi Kishore,

Let me tell you the solution.

Change the declaration of the final table field name to Char(10). It will automatically show you the correct format in the output.

Thanks,

Chidanand

Re: Decimal notation problem when downloading

VikasB — Thu, 30 Oct 2008 11:17:20 GMT

Hi Kishore,

Use the String / Char variable in your final internal table which you are downloading to excel sheet. Then use WRITE statement to output the quantity field into this variable.

e.g.

WRITE g_quantity to g_string LEFT JUTIFIED.

This will automaticaly convert the quantity to the user format.

Regards,

Vikas.