Skip to Content
0
Former Member
Nov 21, 2012 at 09:00 PM

Reg : Formatting Excel

174 Views

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