e.CellElement.Value

Hello Andi,

Thank you for the provided code snippet.

According to it, I suppose that the "Document" column contains numeric values and you color some rows in RadGridView based on some conditions. If I understand you correctly you would like to get the sum of rows that are colored in yellow and have GradientStyles.Radial. To do so, I can suggest to iterate the cells outside the formatting event and use the same condition that you use in the CellFormatting event to calculate the sum. 

Note, since RadGridView uses UI virtualization for its cells the CellFormatting event should be fired many times and it should be used for formatting purposes only. This is why if you want to make some calculations it is suitable to do it outside this event, for example in a separate method:

Class SurroundingClass
    Public Sub New()
        InitializeComponent()
        CalculateSum()
    End Sub

    Private Sub CalculateSum()
        For Each rowInfo In Me.radGridView1.Rows
            For Each cellInfo As GridViewCellInfo In rowInfo.Cells
                If cellInfo.ColumnInfo.Name = "Document" Then
                    If CDec(cellInfo.Value) >= 50 AndAlso CDec(cellInfo.Value) <= 100 Then
                        sum += CDec(cellInfo.Value)
                    End If
                End If
            Next
        Next
        Console.WriteLine(sum)
        Me.radLabel1.Text = sum.ToString()
    End Sub
End Class

I would like to note that RadGridView offers summary rows which may be suitable for your scenario. If you don't want to sum all the cell values, you can construct a custom summary item and override its Evaluate method where you can implement the desired logic for the calculation. Additional information is available in the following help article:  https://docs.telerik.com/devtools/winforms/controls/gridview/rows/summary-rows 

I hope this information helps. If you have further questions please let me know.

Regards,
Nadya
Progress Telerik

Hello Andi,

I am really glad that the suggested solution works for you. Thank you for sharing your feedback about the experience you have with RadGridView control. We really appreciate it. 

Do not hesitate to contact us in case of any further difficulties.

Regards,
Nadya
Progress Telerik

Hi, Andi,

Following the provided information it seems that you would like to enter only numeric values in the text box and later use them in the grid. If you do so, I can suggest to consider using RadMaskedEditBox. RadMaskedEditBox is a themeable text box that formats and constrains text to a predefined pattern or a pattern you define. The MaskType property defines what type of mask would be used in the masked box.

In your case when you want to display decimal values you can set the MaskType to Numeric. I hope you will find it more useful rather than restricting RadTextBox from undesired user input. Thus, the user will be able to type only numeric values without extra commas or other symbols. Please refer to the following articles:
https://docs.telerik.com/devtools/winforms/controls/editors/maskededitbox/maskededitbox
https://docs.telerik.com/devtools/winforms/controls/editors/maskededitbox/numeric-masks

 Could you give RadMaskedEditBox a try and let me know if it is suitable for you.

I am looking forward to your reply.

Regards, Author nickname Progress Telerik

Hi, Andi,

I am really glad that the suggested RadMaskedEditBox control is suitable for your scenario. 

Should you have further questions I will be glad to help.

Regards,
Nadya
Progress Telerik