Back to Devexpress

SpreadsheetCellEventArgsBase.Worksheet Property

officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetcelleventargsbase.md

latest2.7 KB
Original Source

SpreadsheetCellEventArgsBase.Worksheet Property

Gets the worksheet that contains the cell.

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public Worksheet Worksheet { get; }
vb
Public ReadOnly Property Worksheet As Worksheet

Property Value

TypeDescription
Worksheet

A Worksheet object.

|

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Worksheet property.

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.

winforms-spreadsheet-use-custom-cell-editors/CS/DevAVInvoicing/Form1.cs#L137

csharp
return;
Worksheet invoice = e.Worksheet;
Worksheet customerStores = spreadsheetControl1.Document.Worksheets["Stores"];

winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L125

vb
If e.Action = CellValueChangedAction.UndoRedo OrElse e.OldValue Is e.Cell.Value OrElse Not Equals(e.Cell.GetReferenceA1(ReferenceElement.IncludeSheetName), "Invoice!B10") Then Return
Dim invoice As Worksheet = e.Worksheet
Dim customerStores As Worksheet = spreadsheetControl1.Document.Worksheets("Stores")

See Also

SpreadsheetCellEventArgsBase Class

SpreadsheetCellEventArgsBase Members

DevExpress.XtraSpreadsheet Namespace