Abstract base class which exposes the various display options available for a worksheet which can be saved with both a worksheet and a custom view.

DisplayOptions

new DisplayOptions(a: Worksheet): DisplayOptions

Returns DisplayOptions

$t: Type
gridlineColor: any
panesAreFrozen: boolean

showExpansionIndicatorBelowGroupedRows

Section titled "showExpansionIndicatorBelowGroupedRows"
showExpansionIndicatorBelowGroupedRows: boolean

showExpansionIndicatorToRightOfGroupedColumns

Section titled "showExpansionIndicatorToRightOfGroupedColumns"
showExpansionIndicatorToRightOfGroupedColumns: boolean
showFormulasInCells: boolean
showGridlines: boolean
showOutlineSymbols: boolean
showRowAndColumnHeaders: boolean
showRulerInPageLayoutView: boolean
showZeroValues: boolean
view: WorksheetView

Inherited from: DisplayOptionsBase

visibility: WorksheetVisibility

Gets the settings which control the frozen panes in the worksheet.

get frozenPaneSettings(): FrozenPaneSettings

Returns FrozenPaneSettings

Gets the settings which control the unfrozen panes in the worksheet.

get unfrozenPaneSettings(): UnfrozenPaneSettings

Returns UnfrozenPaneSettings

Removes any saved selection information.

clearSelection(): void

Returns void

Inherited from: DisplayOptionsBase

Resets the display options to their default settings.

reset(): void

Returns void