WPF datagrid Currency formatting Converter

Question

I am trying to make a column in WPF datagrid to display currency in the following format:

value <= 9999, display format set to $1,234;
value <= 99999, display format set to $12k;
value >99999, display format set to $12M;

In addition, I would need to have the function that user can see the actual value and edit the value upon mouse click.

I have been trying to get the concept of IValueConverter, but couldn't get a working code.

Can someone help?

Update: with Ramin's answer, it is partially working. Here are the code:

public class DollarConverter : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
    {
        double v = double.Parse(value.ToString());

        if (v <= 9999)
        {
            return v.ToString("C0");
        }
        else if (v <= 999999)
        {
            double vv = v / 1000;
            return vv.ToString("C0") + "K";
        }
        else if (v > 99999)
        {
            double vvv = v / 1000000;
            return vvv.ToString("C0") + "M";
        }

        return v;
    }

    public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
    {
        throw new NotImplementedException();
    }
}

in WPF:Binding="{Binding LBRRev, Converter={StaticResource DollarConverter}}"

score 0 · Answer 1 · answered Feb 14 '17 at 01:10

0

This is not the exact solution, but can help you solve it:

public class StringFormatConverter : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
    {
        int v = int.Parse(value.ToString());

        if (v <= 9999)
            return v.ToString("C0");
        else if (v <= 99999)
            decimal vv = v / 1000;
            return vv.ToString("C0") + "k"; 
        return v;
    }

    public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
    {
        throw new NotImplementedException();
    }
}

Use it in the Binding:

 <DataGridTextColumn  Binding="{Binding Converter={StaticResource StringFormatConverter }}"/>

answered Feb 14 '17 at 01:10

rmojab63

3,513
1
15
28

Have a look at this link: https://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.110).aspx – rmojab63 Feb 14 '17 at 01:13
see http://www.wpf-tutorial.com/data-binding/value-conversion-with-ivalueconverter/ – rmojab63 Feb 14 '17 at 16:59
I got most of it working now. Thanks for the direction. Could you give a bit of suggestion on edit the value on the datagrid? – OptimusPrime Feb 14 '17 at 17:20

score 0 · Accepted Answer · answered Feb 16 '17 at 17:21

After a bit of research, I have a working version now. The converter:

public class DollarConverter : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
    {            
        double v = double.Parse(value.ToString());

        if (v <= 9999)
        {
            return v.ToString("C0");
        }
        else if (v <= 999999)
        {
            return (v/1000).ToString("C0")+"K";
        }
        else if (v > 999999)
        {
            return (v/1000000).ToString("C1") + "M";
        }


        return v;
    }

    public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
    {

        throw new NotImplementedException();
    }
}

In the xaml:

<DataGridTemplateColumn Header="Mat. Rev" Width = "22*">
                    <DataGridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <TextBlock Text="{Binding MatRev, Converter={StaticResource DollarConverter}}"/>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellTemplate>
                    <DataGridTemplateColumn.CellEditingTemplate>
                        <DataTemplate>
                            <TextBox Text="{Binding Path=MatRev, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"/>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellEditingTemplate>
                </DataGridTemplateColumn>

Hope this helps anyone who have the same question.

WPF datagrid Currency formatting Converter

2 Answers2