GrapeCity.Xaml.SpreadSheet.UI
UserFormulaEntered Event (GcSpreadSheet)
Example 


GrapeCity.Xaml.SpreadSheet.UI Namespace > GcSpreadSheet Class : UserFormulaEntered Event
Occurs when the user types a formula.
Syntax
'Declaration
 
Public Event UserFormulaEntered As EventHandler(Of UserFormulaEnteredEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of UserFormulaEnteredEventArgs)
 
AddHandler instance.UserFormulaEntered, handler
public event EventHandler<UserFormulaEnteredEventArgs> UserFormulaEntered
Event Data

The event handler receives an argument of type UserFormulaEnteredEventArgs containing data related to this event. The following UserFormulaEnteredEventArgs properties provide information specific to this event.

PropertyDescription
Gets the column index of the cell in which the user entered a formula.  
Gets the formula that the user entered.  
Gets the row index of the cell in which the user entered a formula.  
Example
This example uses the UserFormulaEntered event.
private void gcSpreadSheet1_UserFormulaEntered(object sender, GrapeCity.Xaml.SpreadSheet.UI.UserFormulaEnteredEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Formula.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }
Private Sub gcSpreadSheet1_UserFormulaEntered(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.UserFormulaEnteredEventArgs) Handles gcSpreadSheet1.UserFormulaEntered
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Formula.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub
See Also