This is a migrated thread and some comments may be shown as answers.

Conditional Formatting on a booleanColumn

8 Answers 544 Views

GridView

This is a migrated thread and some comments may be shown as answers.

8 Answers, 1 is accepted

answered on 14 Nov 2007, 12:12 PM

Hello Chris Castle,

Thank you for writing.

Yes, it is possible to use conditional formatting on a boolean column. The following sample demonstrates how to do this:

DataTable table = new DataTable(); 

table.Columns.Add("ID"); 

table.Columns.Add("Name"); 

table.Columns.Add("Boolean"); 

for (int i = 0; i < 5; i++) 

    table.Rows.Add(i, "Row " + i, true); 

this.radGridView1.MasterGridViewTemplate.AutoGenerateColumns = false; 

this.radGridView1.Columns.Add(new GridViewTextBoxColumn("ID")); 

this.radGridView1.Columns.Add(new GridViewTextBoxColumn("Name")); 

GridViewBooleanColumn column = new GridViewBooleanColumn("Boolean");             

this.radGridView1.Columns.Add(column); 

this.radGridView1.DataSource = table; 

this.radGridView1.RightToLeft = RightToLeft.Yes; 

ConditionalFormattingObject obj = new ConditionalFormattingObject("Condition", ConditionTypes.Greater, "1", "", false); 

obj.CellBackColor = Color.Red; 

this.radGridView1.Columns[2].ConditionalFormattingObjectList.Add(obj); 

this.radGridView1.GridElement.Update(false);

In case you have additional questions, don't hesitate to contact us.

All the best,
Jack
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

answered on 28 Nov 2007, 06:00 PM

Hello Eric,

We tested the solution sent to you and found an issue related to checkbox columns. Unfortunately the conditional formatting does not evaluate these kinds of columns correctly. We will fix this in the upcoming release in December.

As a workaround I can offer you to use the CellFormatting event. Refer to the sample code below:

void radGridView1_CellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e) 

{ 

    if (e.CellElement is GridCheckBoxCellElement) 

    { 

        if ((bool)e.CellElement.Value) 

        { 

            e.CellElement.DrawFill = true; 

            e.CellElement.BackColor = Color.Red; 

        } 

        else 

        { 

            e.CellElement.DrawFill = false; 

        } 

    } 

}

Please, tell us if this solution helps.

Best wishes,
Jack
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

answered on 26 Feb 2008, 04:30 AM

has this issue been resolved? I'm using the Q3 release and I'm having the same issue.

Nevermind.... I figured it out.

I need the row color changed if the marker was set to false which means I needed to use:

ConditionalFormattingObject

obj = new ConditionalFormattingObject("Complete", ConditionTypes.Less, "1", "", true);

Although a little note for Telerik, this seems a little confusing for use with a boolean columns. Is there a way in the future when coding in manually like this, to have the ConditionalFormattingObject overloaded to accept a bool as a value rather than 2 strings? Just a thought.

_________________________________________________________

Correction again.... the above code does indeed change the color of the rows.... but but all my rows were false until, so I didn't see this until now. So now I have a mix of T & F in the same column, and with the above code, all the rows are colored when only the false rows are to be colored... I even tried adding another line to evaluated for true, but that didn't help... its like all or nothing.....