GrapeCity.Xaml.SpreadSheet.Data
ExcelWarning Property
Example 


An ExcelWarning instance used to provide error details.
Syntax
'Declaration
 
Public ReadOnly Property ExcelWarning As ExcelWarning
'Usage
 
Dim instance As ExcelErrorEventArgs
Dim value As ExcelWarning
 
value = instance.ExcelWarning
public ExcelWarning ExcelWarning {get;}
Example
This example uses the ExcelWarning property.
private void gcSpreadSheet1_EditChange(object sender, GrapeCity.Xaml.SpreadSheet.UI.EditCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

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

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

private void gcSpreadSheet1_ExcelError(object sender, GrapeCity.Xaml.SpreadSheet.Data.ExcelErrorEventArgs e)
        {
            listBox1.Items.Add(e.ExcelWarning.Code.ToString());
        }

private void gcSpreadSheet1_InvalidOperation(object sender, GrapeCity.Xaml.SpreadSheet.UI.InvalidOperationEventArgs e)
        {
            listBox1.Items.Add(e.Message.ToString());
        }

private void gcSpreadSheet1_LeaveCell(object sender, GrapeCity.Xaml.SpreadSheet.UI.LeaveCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }
Private Sub GcSpreadSheet1_EditChange(sender As Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.SpreadSheet.Data.ExcelErrorEventArgs) Handles GcSpreadSheet1.ExcelError
        ListBox1.Items.Add(e.ExcelWarning.Code.ToString())
    End Sub

Private Sub GcSpreadSheet1_InvalidOperation(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.InvalidOperationEventArgs) Handles GcSpreadSheet1.InvalidOperation
        ListBox1.Items.Add(e.Message.ToString())
    End Sub

Private Sub GcSpreadSheet1_LeaveCell(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.LeaveCellEventArgs) Handles GcSpreadSheet1.LeaveCell
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

ExcelErrorEventArgs Class
ExcelErrorEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options