Show empty cell if value in currency is 0

Hello Uwe,

Yes, it is possible to achieve this. You can use the CellFormatting event to change the text of the cell if its value is 0:

private void RadGridView1_CellFormatting(object sender, CellFormattingEventArgs e)
       {
            if (e.Column is GridViewDecimalColumn && e.CellElement.Value != null)
            {
                var value = (decimal)e.CellElement.Value;
                if (value == 0)
                {
                    e.CellElement.Text = "";
                }
            }
       }

I hope this helps. Should you have other questions I will be glad to help.

Regards,
Nadya
Progress Telerik

That's obviously the first idea, but i hoped you had a better one. And you do, as i found recently:

          var obj = new ExpressionFormattingObject("Condition_" + colName, colName + " = 0", true) {CellForeColor = Color.Transparent};
          this.Grid.Columns[colName].ConditionalFormattingObjectList.Add(obj);

Hello Uwe,

I am glad that you managed to find another solution to achieve your goal. Thank you for sharing it with the community. Feel free to use this one that suits your requirements the best.

Should you have other questions do not hesitate to ask.

Regards,
Nadya
Progress Telerik