QueryCellStyleInfo

[Ricardo Abranches]

I am trying to use this event (QueryCellStyleInfo) for the following:

when the cell of a given column is less than 1 then e.Style.BackColor = Color.Red

but I can't figure out how to know if I'm in the cell that interests me.

can you give me an example on vb.net

Thank you

Ricardo

[Mohanraj Gunasekaran]

Hi Ricardo, 

 

Thanks for contacting Syncfusion support. 

 

To change the BackColor for specific cells using QueryCellStyleInfo event, you could use the CellValue and Column property. Please refer the following code example and the sample. 

 

VB 

AddHandler Me.gridGroupingControl1.QueryCellStyleInfo, AddressOf GridGroupingControl1_QueryCellStyleInfo 

Private Sub GridGroupingControl1_QueryCellStyleInfo(ByVal sender As Object, ByVal e As GridTableCellStyleInfoEventArgs) 

               If e.TableCellIdentity Is Nothing OrElse e.TableCellIdentity.Column Is Nothing Then 

                              Return 

               End If 

    'To get the specific column 

    If e.TableCellIdentity.Column.Name = "Freight" AndAlso e.TableCellIdentity.DisplayElement IsNot Nothing AndAlso e.TableCellIdentity.DisplayElement.Kind = Syncfusion.Grouping.DisplayElementKind.Record Then 

        Dim text As String = e.Style.CellValue.ToString() 

        Dim value As Double 

        If Double.TryParse(text, value) Then 

            If value > 1000 Then 

                e.Style.BackColor = Color.Red 

                e.Style.TextColor = Color.White 

            End If 

        End If 

    End If 

End Sub 

Screenshot 

 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/VB805667005  

Please refer the following KB link, 

https://www.syncfusion.com/kb/640/how-do-i-conditionally-set-the-format-of-a-single-cell-in-the-gridgroupingcontrol 

Please get back to us if you need any further assistance on this. 

Regards, 

Mohanraj G 

[Ricardo Abranches]

Thanks for your help.

Best regards

[Arulpriya Ramalingam]

Hi Ricardo, 

 

Thanks for the update. 

 

We are glad to know that the reported use case is resolved at your end and we are happy to assist you. Please revert to us, if you have any other queries. 

 

Regards, 

Arulpriya