Skip to main content

SpreadsheetControl.UnhandledException Event

This event is raised when an exception, unhandled by the SpreadsheetControl, occurs.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet


public event UnhandledExceptionEventHandler UnhandledException

Event Data

The UnhandledException event's data class is SpreadsheetUnhandledExceptionEventArgs. The following properties provide information specific to this event:

Property Description
Exception Gets the exception which triggers the UnhandledException event.
Handled Gets or sets whether the exception should be propagated upwards.


The UnhandledException event is helpful when a command is executed via the Bar (Ribbon) user interface, and you are unable to catch the exception which is likely to occur. The most common case is an attempt to save the document to a read-only or locked file. If you do not handle the UnhandledException event, the unhandled exception is thrown and the application crashes. All changes in the document are lost. To prevent this, handle the exception using the following code.

private void spreadsheetControl1_UnhandledException(object sender, 
    DevExpress.XtraSpreadsheet.SpreadsheetUnhandledExceptionEventArgs e)
    e.Handled = true;
    // Add your code to handle the exception.
    BeginInvoke(new MethodInvoker(delegate()
        MessageBox.Show(e.Exception.Message, "The command is not completed!");
See Also