.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Workbook.PanesFrozen Event

Occurs after a worksheet area has been frozen.

You need an active 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.v20.1.dll


public event PanesFrozenEventHandler PanesFrozen
Public Event PanesFrozen As PanesFrozenEventHandler

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.


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.


This event does not occur by default. The event fires only if the WorkbookEventOptions.RaiseOnModificationsViaAPI property is true.


See Also