SpreadsheetControl.DocumentLoaded Event

Occurs after a document is loaded into the SpreadsheetControl.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v18.2.dll

Declaration

C#

public event EventHandler DocumentLoaded

VB.NET

Public Event DocumentLoaded As EventHandler

Event Data

The DocumentLoaded event's data class is EventArgs.

Remarks

The DocumentLoaded event fires after the LoadDocument method of the SpreadsheetControl or IWorkbook object is executed when the document model is built and the loaded document is valid. Handle the DocumentLoaded event to ensure that the document is loaded completely so you can safely modify it.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DocumentLoaded event.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/CS/UDF_Discount/Form1.cs#L24

spreadsheetControl1.DocumentLoaded+=spreadsheetControl1_DocumentLoaded;
spreadsheetControl1.LoadDocument("Discount.xlsx");

formula-engine-examples-of-use-t110344/CS/FormulaEngineTest/Form1.cs#L25

SetCellContext();
spreadsheetControl1.DocumentLoaded += spreadsheetControl1_DocumentLoaded;
spreadsheetControl1.ActiveCell.Formula = "SUM(R[1]C:R[2]C)";

how-to-assign-custom-in-place-editors-to-worksheet-cells-t385401/CS/Spreadsheet_CustomCellEditors/Form1.cs#L15

spreadsheetControl.DocumentLoaded += spreadsheetControl1_DocumentLoaded;
#region #CustomCellEdit

VB.NET

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/VB/UDF_Discount/Form1.vb#L24

AddHandler spreadsheetControl1.DocumentLoaded, AddressOf spreadsheetControl1_DocumentLoaded
spreadsheetControl1.LoadDocument("Discount.xlsx")

formula-engine-examples-of-use-t110344/VB/FormulaEngineTest/Form1.vb#L24

SetCellContext()
AddHandler spreadsheetControl1.DocumentLoaded, AddressOf spreadsheetControl1_DocumentLoaded
spreadsheetControl1.ActiveCell.Formula = "SUM(R[1]C:R[2]C)"

how-to-assign-custom-in-place-editors-to-worksheet-cells-t385401/VB/Spreadsheet_CustomCellEditors/Form1.vb#L14

            AddHandler spreadsheetControl.DocumentLoaded, AddressOf spreadsheetControl1_DocumentLoaded
'            #Region "#CustomCellEdit"