UserFormulaEntered Event (GcSpreadSheet)

Occurs when the user types a formula.

Syntax

Visual Basic
C#

'Declaration
 
Public Event UserFormulaEntered As System.EventHandler(Of UserFormulaEnteredEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of UserFormulaEnteredEventArgs)
 
AddHandler instance.UserFormulaEntered, handler

public event System.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.

Property	Description
Column	Gets the column index of the cell in which the user entered a formula.
Formula	Gets the formula that the user entered.
Row	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.Windows.SpreadSheet.UI.UserFormulaEnteredEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Formula.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

VB.NET

Private Sub GcSpreadSheet1_UserFormulaEntered(sender As System.Object, e As GrapeCity.Windows.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

Reference

GcSpreadSheet Class
GcSpreadSheet Members

Product Support Forum | Print this page