Hi,
I need to display a decimal with currency format depending on a parameter selected in a dropdown for each row of the grid. So I could have selected USD in one row and eur on the next. I use a GridColumnSetting like this.
new GridColumnSetting{
Key="Amount", Title = "Amount", Format="{0:c}", Type =System.Type.GetType("System.Double") }
This will format the number as currency according to the current local CultureInfo. I need to change this depending on the value selected for each row in the grid.
Is this possible?
Thanks in advance.
Hello Carlos,
Thank you for contacting Infragistics!
There isn’t a way to set a separate culture for each row. You will have to set the formatfieldMethod and format the cell values there based on the culture you want or otherwise format them on the server:
http://help.infragistics.com/doc/ASPNET/2016.1/CLR4.0/?page=Infragistics4.Web.v16.1~Infragistics.Web.UI.GridControls.ControlDataField~FormatFieldMethod.html
http://help.infragistics.com/doc/ASPNET/2016.1/CLR4.0/?page=Infragistics4.Web.v16.1~Infragistics.Web.UI.GridControls.FormatRecordItemValue.html