How can I change the background color of a cell after editing the value

[George Busby]

I know that you can use conditional formatting to change the background color but that is based on a criteria. I went to be able to change the background color of a cell after the value has changed so I can visually see all cells that were modified within the PivotGrid. This is in the Winforms version of the control.

[George Busby]

I was able to find a way to change the color of the background when a cell is edited.  here is the code I created, is this the correct way to do it?

 Dim CellStyle As New Syncfusion.Windows.Forms.Grid.GridStyleInfo

 Me.PivotGridControl1.TableModel.GetCellInfo(Me.PivotGridControl1.TableControl.CurrentCell.RowIndex, Me.PivotGridControl1.TableControl.CurrentCell.ColIndex, CellStyle)

 CellStyle.BackColor = Color.AliceBlue

 Dim MyType As Syncfusion.Styles.StyleModifyType

 MyType = Syncfusion.Styles.StyleModifyType.Changes

 Me.PivotGridControl1.TableModel.SetCellInfo(Me.PivotGridControl1.TableControl.CurrentCell.RowIndex, Me.PivotGridControl1.TableControl.CurrentCell.ColIndex, CellStyle, MyType)

[Thirupathi Bala Krishnan]

Hi George,

We have analyzed the reported query – “How to change the background color value for the edited cell”. You can achieve this requirement by defining the back color and font styles inside the PrepareViewStyleInfo event handler. You can find out the row and column index values of edited cell by using the CurrentCell property.

 

Please refer the following code sample.

 

#Form1.vb 

 

Imports Syncfusion.Windows.Forms.Grid 

Imports System.Drawing 

 

Private isEditingCompleted As Boolean

 

        Public Sub New() 

            InitializeComponent() 

            PivotGridSettings() 

            AddHandler pivotGridControl1.TableControl.CurrentCellStartEditing, AddressOf Me.TableControl_CurrentCellStartEditing 

            AddHandler pivotGridControl1.TableControl.CurrentCellEditingComplete, AddressOf Me.TableControl_CurrentCellEditingComplete 

            AddHandler pivotGridControl1.TableControl.PrepareViewStyleInfo, AddressOf Me.TableControl_PrepareViewStyleInfo 

        End Sub

 

        Private Sub TableControl_CurrentCellEditingComplete(ByVal sender As Object, ByVal e As EventArgs) 

            isEditingCompleted = True 

        End Sub 

 

        Private Sub TableControl_PrepareViewStyleInfo(ByVal sender As Object, ByVal e As GridPrepareViewStyleInfoEventArgs) 

            If isEditingCompleted AndAlso e.ColIndex = pivotGridControl1.TableControl.CurrentCell.ColIndex - 1 AndAlso e.RowIndex = pivotGridControl1.TableControl.CurrentCell.RowIndex Then 

                e.Style.BackColor = Color.Orange 

                e.Style.Font.Bold = True 

                e.Style.Font.Italic = True 

                isEditingCompleted = False 

            End If 

        End Sub 

 

 

 

Before editing the cell value, 

 

After editing the cell value,

 

 

Please let us know if you need any further assistance.

Regards,
Thirupathi B.