Workbook.PanesFrozen Event
Occurs after a worksheet area has been frozen.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Docs.v23.2.dll
NuGet Package: DevExpress.Document.Processor
Declaration
Event Data
The PanesFrozen event's data class is PanesFrozenEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| ColumnOffset | Gets the offset of the last frozen column relative to the first column in a worksheet or the left-most column with the specified cell from where freezing starts. |
| RowOffset | Gets the offset of the last frozen row relative to the first row in a worksheet or the top row with the specified cell from where freezing starts. |
| TopLeft | Gets the cell contained in a top frozen row and/or left-most frozen column from where freezing starts. |
Remarks
Handle the PanesFrozen event to perform specific actions when worksheet rows and columns are locked via the Worksheet.FreezeRows, Worksheet.FreezeColumns, or Worksheet.FreezePanes method.
Note
This event does not occur by default. The event fires only if the WorkbookEventOptions.RaiseOnModificationsViaAPI property is true.