Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetControl.PanesFrozen Event

Occurs when freezing a worksheet area via the control’s UI.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

#Declaration

public event PanesFrozenEventHandler PanesFrozen

#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 an end-user locks (freezes) rows and columns on a worksheet via the control’s UI.

Note

By default, the PanesFrozen event does not occur when rows and columns are frozen in code. However, this event will also be triggered by changes made via an API if you set the WorkbookEventOptions.RaiseOnModificationsViaAPI property (accessible via the SpreadsheetControl.Options.Events.RaiseOnModificationsViaAPI notation) to true.

See Also