Cell Editability Binding

[Harald Betzler]

Hi,

I want to realize a SfDataGrid with some columns, where each cells of one particular column should be editable based on the content of other columns.

As you can see in the attached screenshot, the cells in column "Value" should not be enabled when "ItemType" == 2 && "ItemSubType" == null but enabled in all other cases "ItemType" !=2 || "ItemSubType" != null.

(A part of the solution could be a new (hidden) column "IsEditable" with content of type bool = "ItemType !=2 && ItemSubType != null")

Editable cells should have CellStyle = "BlueStyle" and not editable cells should have CellStyle = "DarkGrayStyle".

I've also attached a sample application.

Regards

Harald

Attachment: SfGridSample5_ba5384fb.zip

[Jai Ganesh S]

Hi Harald, 

 

You can achieve your requirement for style the cells based on the enabled/disabled  by using CurrentCellBeginEdit and CellStyleSelector like below, 

 

Enable/Disable the cell base on certain condition: 

 

this.SampleDataGrid.CurrentCellBeginEdit += SampleDataGrid_CurrentCellBeginEdit; 

 

private void SampleDataGrid_CurrentCellBeginEdit(object sender, CurrentCellBeginEditEventArgs args) 

{ 

    if(args.Column.MappingName=="Value") 

    { 

        var rowIndex = args.RowColumnIndex.RowIndex; 

        var recordIndex = this.SampleDataGrid.ResolveToRecordIndex(rowIndex); 

        var record = this.SampleDataGrid.View.Records[recordIndex].Data as DataItem; 

 

 

        if (record.ItemType == 2 && record.ItemSubType == null) 

            args.Cancel = true; 

    } 

} 

 

Apply the style for the cell based on Enable/Disable: 

 

public class CustomStyleSelector:StyleSelector 

{ 

    public override Style SelectStyle(object item, DependencyObject container) 

    { 

        var data = item as DataItem; 

 

        if(data.ItemType==2 && data.ItemSubType==null) 

            return Application.Current.FindResource("DarkGrayStyle") as Style; 

        else 

            return Application.Current.FindResource("BlueStyle") as Style; 

 

 

        return base.SelectStyle(item, container); 

    } 

} 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SfGridSample-1740322252.zip 

 

Screen Shot: 

 

 

References: 

https://help.syncfusion.com/wpf/sfdatagrid/editing#currentcellbeginedit-event 

https://www.syncfusion.com/kb/2604/how-to-disable-edit-mode-for-cells-in-sfdatagrid-with-different-background-for-those-disabled-cells 

Regards, 

Jai Ganesh S 

[Harald Betzler]

Hi Jai,

thank you for your help. 

You realized the requirement of "locked" cells with cancelling edit within the CurrentCellBeginEdit event. But wouldn't it be better to bind AllowEdit property to the datasource?

And the cell style (BlueStyle for editable and DarkGrayStyle for non editable) is completely not realized in your approach.

Regards

Harald

[Sivakumar R]

Hi Harald,  

 

Please find the details for your queries, 

 

Query	Details
You realized the requirement of "locked" cells with cancelling edit within the CurrentCellBeginEdit event. But wouldn't it be better to bind AllowEdit property to the datasource?	It is possible to set AllowEditing for column, but no direct way to set AllowEditing for each cell. If you want to handle editing in cell basics, then handling CurrentCellBeginEdit event is the best way.    In another way, set the IsEnabled property in style as false instead of handling CurrentCellBeginEdit event. So the cell won’t get into edit mode and also it is not possible to select the cell by user.    <Style x:Key="DarkGrayStyle" TargetType="{x:Type sf:GridCell}">      <Setter Property="Background" Value="DarkGray" />      <Setter Property="IsEnabled" Value="False"/>      <Setter Property="Padding" Value="20 0" />  </Style>
the cell style (BlueStyle for editable and DarkGrayStyle for non editable) is completely not realized in your approach.	We could not get your query clearly. Style also realized in Style selector. Please refer the code snippet below,    public class CustomStyleSelector:StyleSelector   {       public override Style SelectStyle(object item, DependencyObject container)       {           var data = item as DataItem;           if(data.ItemType==2 && data.ItemSubType==null)               return Application.Current.FindResource("DarkGrayStyle") as Style;           else               return Application.Current.FindResource("BlueStyle") as Style;           return base.SelectStyle(item, container);       }   }

 

Thanks, 

Sivakumar 

[Harald Betzler]

Hi Sivakumar,

thank you for the hints.

Your suggestion (for query 1) is to set property IsEnabled to false. It is correct that the cells can't be selected anymore - by mouse. But they can be selected by keyboard (while moving through the grid with arrow keys). And it is also possible to enter characters although the cells IsEnabled property is set to false.

In my eyes this is a bug and should be fixed.

Please find an attached simple sample with the descriped issue.

Regards

Harald

Attachment: SfGridSample12_f26b0f40.zip

[Jai Ganesh S]

Hi Harald, 

Query 1: 

We have not skipped to select the disabled cell while key navigation. Hence the current cell is maintained while key navigation. However, you can avoid to set the selection for the disabled cell by using CurrentCellActivating event like below,   

this.AssociatedObject.CurrentCellActivating += AssociatedObject_CurrentCellActivating;  

 

  private void AssociatedObject_CurrentCellActivating(object sender, CurrentCellActivatingEventArgs e) 

        { 

            if (this.AssociatedObject.Columns[e.CurrentRowColumnIndex.ColumnIndex].MappingName == "Value") 

            { 

                var rowIndex = e.CurrentRowColumnIndex.RowIndex; 

                var recordIndex = this.AssociatedObject.ResolveToRecordIndex(rowIndex); 

                var record = this.AssociatedObject.View.Records[recordIndex].Data as DataItem; 

 

                if (record.ItemType == 2) 

                    e.Cancel = true; 

            } 

        }  

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SfGridSample2022466314.zip 

Query 2: And it is also possible to enter characters although the cells IsEnabled property is set to false. 

We regret to inform you that, you cannot go to edit mode for the disabled cell. This is the default behavior of SfDataGrid.  

Regards, 

Jai Ganesh S  

[Harald Betzler]

Hi Jai,

Query 1:

Thank you for the sample. This solution is ok, but it would be better, if the next editable cell would be selected. Is this possible?

Query 2:

You did not understand me.

I agree with you: When a cell is configured to IsEnabled="false", no entries should be possible. But entries are possible.

Use my uploaded sample, move with arrow keys to a gray cell and then enter a character. It will be displayed in the "disabled" cell.

Regards

Harald

[Jai Ganesh S]

Hi Harald, 

As we already said in our previous update , the key board interactions are not skipped for the disabled cell but we cannot interact the disabled cell using mouse.  Also you can avoid to type the value for the disabled cell by wiring CurrentCellBeginEdit event ( as we already said in our one of the previous update) like below, 

private void AssociatedObject_CurrentCellBeginEdit(object sender, CurrentCellBeginEditEventArgs e) 

        { 

            if (this.AssociatedObject.Columns[e.RowColumnIndex.ColumnIndex].MappingName == "Value") 

            { 

                var rowIndex = e.RowColumnIndex.RowIndex; 

                var recordIndex = this.AssociatedObject.ResolveToRecordIndex(rowIndex); 

                var record = this.AssociatedObject.View.Records[recordIndex].Data as DataItem; 

 

                if (record.ItemType == 2) 

                { 

                    e.Cancel = true; 

                } 

 

            } 

        } 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SfGridSample-447420980.zip 

Regards, 

Jai Ganesh S