Conditional formatting on a radgridview to remove '-' - C#

Question

I have a rad grid view which contains data relating to stock movement. The values in a column named will all be pulled through as negative. I want to add formatting so that the negative is removed from the number.

I think conditional formatting is how I want to do this, I'm unsure of what I want to do after the condition is met.

ConditionalFormattingObject obj = new ConditionalFormattingObject("MyCondition", ConditionTypes.StartsWith, "-", "", false);
obj.CellBackColor = Color.SkyBlue;
obj.CellForeColor = Color.Red;
obj.TextAlignment = ContentAlignment.MiddleRight;
this.rgv_orderLines.Columns["Moved so Far"].ConditionalFormattingObjectList.Add(obj);

The above code will turn the cells blue when the condition is met. I however, don't want this I want the '-' to be removed.

EDIT: The following code gives the desired result, however, without the try catch it crashes on any cells that don't contain a value.

    private void rgv_orderLines_CellFormatting(object sender, CellFormattingEventArgs e)
    {
        if (e.CellElement.ColumnInfo.Name == "Moved so Far")
        {
            try
            {
                string value = e.CellElement.Value.ToString();
                value = value.Replace("-", "");
                e.CellElement.Value = value;
            }
            catch (Exception ex)
            {

            }
        }
    }

what is the type of the column? Is it a `GridViewDecimalColumn`? — Rhumborl, Mar 01 '18 at 12:57
The column pulls through data from a SQL query I belive the data is pulled through as a string. — benjiiiii, Mar 01 '18 at 13:01
OK just check `if(e.CellElement.Value != null)` around it instead of the `try..catch` — Rhumborl, Mar 01 '18 at 13:10

score 1 · Accepted Answer · answered Mar 01 '18 at 13:09

ConditionalFormattingObject is used only to style the row, i.e. setting fonts and colours. It does not have functionality for formatting data values.

Ideally, you should store the data as positive numbers in the first place, as that makes sorting, filtering etc. much easier. But if you do want to just display the value as positive, you should make sure the column is a GridViewDecimalColumn and set the FormatString of the column to something like

"#.###;#.###;0"

This means display the value with 3 decimal places, for both positive and negative numbers, and as 0 for 0.

If it is a string column, your code wold work, just check if the Value is null before formatting it:

private void rgv_orderLines_CellFormatting(object sender, CellFormattingEventArgs e)
{
    if (e.CellElement.ColumnInfo.Name == "Moved so Far")
    {
        if(e.CellElement.Value != null)
        {
            string value = e.CellElement.Value.ToString();
            value = value.Replace("-", "");
            e.CellElement.Value = value;
        }
    }
}

Hi, the null check is what I had before putting a try catch in but that causes the program to crash as soon as data is loaded in. — benjiiiii, Mar 01 '18 at 13:13
I'm changing the way it works and have made the column a decimal column — benjiiiii, Mar 01 '18 at 13:19
rgv_orderLines.Columns["Moves so Far"].FormatString = "#.###;#/###;0"; — benjiiiii, Mar 01 '18 at 13:20
this is causing the program to crash due to null being found, do I just need to add a null check? — benjiiiii, Mar 01 '18 at 13:20

Conditional formatting on a radgridview to remove '-' - C#

1 Answers1