SpreadsheetControl.PanesFrozen Event
Occurs after a worksheet area has been frozen via the SpreadsheetControl‘s UI.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.XtraSpreadsheet.v18.2.dll
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 an end-user freezes rows and columns on a worksheet via the control’s UI. After a frozen worksheet area has been unlocked, the SpreadsheetControl.PanesUnfrozen event is raised.
Note
By default, the PanesFrozen event does not occur when freezing rows and columns 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.