FlexGrid

[pvbangera]

I am using FlexGrid control of ComponentOne on my form having 3 cols.

I want to change the value of 3 col when 2nd col's value changes. I have written the following code:

Private Sub grdSHP_CellChanged(ByVal sender As Object, ByVal e As C1.Win.C1FlexGrid.RowColEventArgs) Handles grdSHP.CellChanged
        With grdSHP
            If e.Row = 0 Or e.Col = 0 Then
                Exit Sub
            End If
            If Val(.get_TextMatrix(15, 2)) = 0 Then
                .set_TextMatrix(e.Row, 2, "0") '***Here I get the error***
            Else
                .set_TextMatrix(e.Row, 2, Val(.get_TextMatrix(15, 2)) * Val(.get_TextMatrix(e.Row, 1)) / 100)
            End If
        End With
    End Sub

This is not working.

Pls guide me if there's any other way.

Regards,

Prakash