Class which controls the way frozen panes are arranged and used for a worksheet.

FrozenPaneSettings

new FrozenPaneSettings(a: DisplayOptions): FrozenPaneSettings

Returns FrozenPaneSettings

Inherited from: PaneSettingsBase

Gets or sets the first visible column in the right pane(s) of the worksheet.

get firstColumnInRightPane(): number

Returns number

set firstColumnInRightPane(a: number): void

Parameters

  • a: number

Returns void

Inherited from: PaneSettingsBase

Gets or sets the first visible row in the bottom pane(s) of the worksheet.

get firstRowInBottomPane(): number

Returns number

set firstRowInBottomPane(a: number): void

Parameters

  • a: number

Returns void

Gets or sets the number of columns frozen at the left of the worksheet.

get frozenColumns(): number

Returns number

set frozenColumns(a: number): void

Parameters

  • a: number

Returns void

Gets or sets the number of rows frozen at the top of the worksheet.

get frozenRows(): number

Returns number

set frozenRows(a: number): void

Parameters

  • a: number

Returns void

Inherited from: PaneSettingsBase

Resets the pane settings to their defaults.

reset(): void

Returns void

Resets the frozen pane settings to their defaults.

resetCore(): void

Returns void