cell format with currency symbol

Dec 22, 2012 at 10:25 PM
Edited Dec 23, 2012 at 12:57 PM

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