11-21-2012 9:00 PM
Hi All,
I am sending a mail with an excel attachment. in the excel sheet i have done all the formatting stuff and i am displaying the numbers also in the excel correctly bu using the below code
g_format1 = g_document->create_simple_element( name = 'NumberFormat' parent = g_style1 ).
g_format1->set_attribute_ns( name = 'Format' prefix = 'ss' value = '0.00' ).
g_data->set_attribute_ns( name = 'Type' prefix = 'ss' value = 'Number' ). " Cell format
but when a cell in the excel is having a negative value the excel is not opening. can any one please tell me how to handle the negative value in the excel.
Thanks and Regards,
M.Phanindra
11-22-2012 1:53 AM
Hello
In SAP the negative sign by default come after the number. In order place the negative sign before the number the following function module should be used.
CLOI_PUT_SIGN_IN_FRONT
Then send the value to the excel file
Hope this works for you
Thanks
Sandeep