Color cells based on errors
Massimo Cicognani ,
To achieve your requirement of colorizing rows and cells based on some data in the SfDataGrid, you can utilize conditional styling. The SfDataGrid provides support for conditional styling through various methods:
1. Styling using a converter: You can define a converter that takes the data as input and returns the appropriate style or color based on the specified conditions.
2. Styling based on the record using a converter: Similar to the previous method, you can use a converter to examine the record's properties and determine the appropriate style or color.
3. Styling using a style selector: With a style selector, you can define different styles or colors based on specific criteria, such as data values or record properties.
UG Link : https://help.syncfusion.com/wpf/datagrid/conditional-styling
Reference Image :
|
|
Note : In WPF DataGrid, styling the cells takes higher priority than styling the entire row.
We have provided a sample for your reference using a style selector. Please review the sample and verify if it meets your requirements. If we have misunderstood your requirement kindly share the details about details on how you define the error , please share that information with us. This will help us proceed further and provide a solution as quickly as possible.
Attachment: DataGridWithDataTable_6be71b29.zip
Hello, (1) DataTableError is related to the sfDataGrid only with the cell coords that are the DataTable cells coords (the DataTable is the ItemSource i passed to the sfDataGrid), but it is not passed to the sfDataGrid, i used the ErrorList only to discover where my errors are.
Searching on the web, after thousands of sites and forums i find a way to do that, the only problem is that if i change column order or i sort the data, the color are connected to the cell and i don't know how to reorder the style with the data
[
public override Style SelectStyle(object item, DependencyObject container)
{
GridCell cell = container as GridCell;
bool hasError = false;
foreach (DataTableErrors error in errors)
{
if (cell.ColumnBase.RowIndex == error.row + 1)
{
if (error.errorGravity == ErrorGravity.Error || error.errorGravity == ErrorGravity.Warning)
hasError = true;
if(cell.ColumnBase.ColumnIndex == error.column)
{
switch (error.errorGravity)
{
case ErrorGravity.Error:
return AnalyzedData.errorStyle;
case ErrorGravity.Warning:
return AnalyzedData.warningStyle;
case ErrorGravity.Info:
return AnalyzedData.infoStyle;
}
}
}
}
if(hasError)
//se sono in una riga con errori ma la cella non ne ha evidenzio semplicemente la cella
return AnalyzedData.highlightStyle;
return base.SelectStyle(item, container);
}
]
This is what i have done
And this is what happened if i sort data
