Reg : Formatting Excel

Former Member — Wed, 21 Nov 2012 21:00:51 GMT

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

Re: Reg : Formatting Excel

Former Member — Thu, 22 Nov 2012 01:53:40 GMT

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

topic Reg : Formatting Excel in Application Development and Automation Discussions

Reg : Formatting Excel

Re: Reg : Formatting Excel