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

Set_Format in Excel and Curr code

Former Member

‎09-25-2007 6:51 AM

0 Kudos

Hello Abapers,

Iam using 'I_OI_SPREADSHEET' concept to export data from screen to Excel.

Iam using the method 'SET_FORMAT' to set diff formats as my data includes

(CURR , Texts etc). But , iam not sure how to use this method for CURR?

Below is a part of my code:

CALL METHOD g_handle->set_format

EXPORTING

rangename = 'RANGE3'

typ = -1

currency = ' '

no_flush = ' '

decimals = 2

IMPORTING

retcode = retcode.

Could any one give me an idea as to wht to/ How to pass for this param currency ? Any example code wud be appreciated.

Thanks,

Sri

2 REPLIES 2

Former Member

‎09-25-2007 7:39 AM

0 Kudos

Hi Sri,

Please check the link -:)

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCIOFFI/BCCIOFFI.pdf

Thanks and Best Regards,

Vinoth

Former Member
In response to Former Member

‎09-25-2007 8:23 AM

0 Kudos

Hello Vinoth,

Thanks for the link but even there it doesn't clearly specify how CURR fields shld be handled.