Spread Silverlight Documentation
UserFormulaEntered Event (GcSpreadSheet)
Example 


Occurs when the user types a formula.
Syntax
'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.

PropertyDescription
ColumnGets the column index of the cell in which the user entered a formula.  
FormulaGets the formula that the user entered.  
RowGets 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());
        }
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
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.