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

UnfrozenPaneSettings

new UnfrozenPaneSettings(a: DisplayOptions): UnfrozenPaneSettings

Returns UnfrozenPaneSettings

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

get firstColumnInLeftPane(): number

Returns number

set firstColumnInLeftPane(a: number): void

Parameters

  • a: number

Returns void

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 first visible row in the top pane(s) of the worksheet.

get firstRowInTopPane(): number

Returns number

set firstRowInTopPane(a: number): void

Parameters

  • a: number

Returns void

Gets or sets the width of the left pane in twips (1/20th of a point).

get leftPaneWidth(): number

Returns number

set leftPaneWidth(a: number): void

Parameters

  • a: number

Returns void

Gets or sets the height of the top pane in twips (1/20th of a point).

get topPaneHeight(): number

Returns number

set topPaneHeight(a: number): void

Parameters

  • a: number

Returns void

Inherited from: PaneSettingsBase

Resets the pane settings to their defaults.

reset(): void

Returns void

Resets the unfrozen pane settings to their defaults.

resetCore(): void

Returns void