I'm having issues displaying data with the currency symbol in a Developer Express XtraGrid control.
The column(s) in questions are float and decimal data types.
Basically it seems to be ignoring formatting when
...either set through the designer...
Select the "Main" section on the Left Click "Columns" Add my columns, to each one setting the Fieldname , then Display Format : DisplayFormat / FormatString = c2 DisplayFormat / FormatType = Numeric
...and also at runtime..
DevExpress.Utils.FormatInfo fi = new DevExpress.Utils.FormatInfo();
fi.FormatType = DevExpress.Utils.FormatType.Numeric;
fi.FormatString = "c2";
gridColumn3.DisplayFormat.Assign(fi); //Denomination
gridColumn5.DisplayFormat.Assign(fi); //Value
Neither has any effect whatso ever.
I notice someone else had what seems to be the same issue here on the devexpress site: http://www.devexpress.com/Support/Center/p/Q302261.aspx
The sample project provioded by Ted works fine this end, and when I change the DisplayFormat to Numeric "c2" this shows the currentcy symbol as I would like
Thinking that it's a strange property that has been set somewhere in the XtraGrid, I've added a brand new one to the form, setting nothing other than the columns to populate, and the DisplayFormat as described above.
Still no Luck.
Any ideas? Many thanks
I've given up using the designer. Hardcoding it the long way seems to work. Welcome back to 1987...