Spread Silverlight Documentation
ExcelError Event (GcSpreadSheet)
Example 


Occurs when an error occurs during loading or saving an Excel-formatted file.
Syntax
'Declaration
 
Public Event ExcelError As System.EventHandler(Of ExcelErrorEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of ExcelErrorEventArgs)
 
AddHandler instance.ExcelError, handler
public event System.EventHandler<ExcelErrorEventArgs> ExcelError
Event Data

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

PropertyDescription
ExcelWarningAn ExcelWarning instance used to provide error details.  
Example
This example uses the ExcelError event.
private void gcSpreadSheet1_EditChange(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_EditEnd(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_EditStarting(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellStartingEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_ExcelError(object sender, GrapeCity.Windows.SpreadSheet.Data.ExcelErrorEventArgs e)
        {
            listBox1.Items.Add(e.ExcelWarning.Code.ToString());
        }
Private Sub GcSpreadSheet1_EditChange(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs) Handles GcSpreadSheet1.EditChange
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Private Sub GcSpreadSheet1_EditEnd(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs) Handles GcSpreadSheet1.EditEnd
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Private Sub GcSpreadSheet1_EditStarting(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellStartingEventArgs) Handles GcSpreadSheet1.EditStarting
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Private Sub GcSpreadSheet1_ExcelError(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.Data.ExcelErrorEventArgs) Handles GcSpreadSheet1.ExcelError
        ListBox1.Items.Add(e.ExcelWarning.Code.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.