Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Doubt in using the function module SO_DOCUMENT_SEND_API1

Former Member

‎2008 Jun 12 1:29 PM

0 Likes
360

Hi ,

My requirement is sending an excel sheet to the mail id's given in excel sheet.I am using the FM:SO_DOCUMENT_SEND_API1.I complete the program. It is working good.My problem here is once I received the excel sheet , if the amount value is 123.00. i can see only 123. As if the amount value is 123.78, i can see the value 123.78.I can see the value perfectly in debug mode , but the valus has been truncated in excel sheet .

Can anyone give me the idea how to correct this ?

Thanks,

Suresh.

Most likely reason seems to be that Excel is being overly friendly and fixing formats for you - e.g. if you have a column containing a PO reference such as 4500001234 then it will assume this is a number that can be included in calculations for format it as general, and not a text string that just happens to contain only numbers. You can fix this once the data is in Excel by formatting the cells the way you want.

Jonathan

Reply
1 REPLY 1
Read only

Former Member

‎2008 Jun 12 1:43 PM

0 Likes
347

Most likely reason seems to be that Excel is being overly friendly and fixing formats for you - e.g. if you have a column containing a PO reference such as 4500001234 then it will assume this is a number that can be included in calculations for format it as general, and not a text string that just happens to contain only numbers. You can fix this once the data is in Excel by formatting the cells the way you want.

Jonathan