Application Development 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: 

Output problem in XL sheet

Former Member
0 Kudos

Hi Gurus,

In my report, output is coming in XL sheet. But in XL sheet group currency and carry forward column values are not in correct allignment. I used "EXCEL_OLE_STANDARD_DAT' function module to get output in XL SHEET

Group Currency Carry Forward Balanc

0 2552.91

87150.12- 87150.12-

27157.97 27157.97

0 2300

7496.69 7496.69

4789.34- 4789.34-

197533.71- 202395.71-

0 9.09

33465.58- 33465.58-

i want the negative values should be correct allignment like " -87150.12".

I tried Gui_download, but its not working .Please suggetst me solution .

Thanks & Regards,

Chiru.

1 ACCEPTED SOLUTION

former_member181962
Active Contributor
0 Kudos

Use the function module CLOI_PUT_SIGN_IN_FRONT for the group currency field and then pass it to the function module that downloads the data to excel.

Regards,

Ravi kanth Talagana

5 REPLIES 5

former_member181962
Active Contributor
0 Kudos

Use the function module CLOI_PUT_SIGN_IN_FRONT for the group currency field and then pass it to the function module that downloads the data to excel.

Regards,

Ravi kanth Talagana

0 Kudos

Hi Gurus,

I used this fm "CLOI_PUT_SIGN_IN_FRONT" but it is not working,

In the group currency and carry forward some values are coming "3456- ", "12456.23-".

. It should come -3456 and -12456.23 in correct format.

Regards,

Chiru.

0 Kudos

Hi ,

Please reply and send me solution.

Former Member
0 Kudos

you can do it this way.

data: p_amt type char.
p_amt = t_pa-amt.
if t_pa-amt < 0.
len = strlen( p_amt ) - 1.
concatenate '-' p_amt+0(len) into p_amt.
endif.

Regards,

Lalit Mohan Gupta.

0 Kudos

Hi,

Thanks for your reply, but it is not working. Please suggest me if any other solution.

Regards,

Chiranjeevi.