cell format with currency symbol

Dec 22, 2012 at 9:25 PM
Edited Dec 23, 2012 at 11:57 AM

I cannot properly format the cell with currency symbol (€ or $) obtaining a correct result in the spreadsheet (I mean the currency symbol in the formatted cell but not only "0.00").

I tried in many ways (

stylecel.DataFormat = HSSFDataFormat.GetBuiltinFormat("€0.00"), stylecel.DataFormat = HSSFDataFormat.GetBuiltinFormat("€ 0.00"), stylecel.DataFormat = HSSFDataFormat.GetBuiltinFormat("€#.##") ,stylecel.DataFormat = HSSFDataFormat.GetBuiltinFormat("€ #.##")

)

What am I doing wrong?

Thanks for support

 

P.S. I solved with GetFormat that really Format Currency symbol. GetBuiltinFormat is not doing the same