Class which exposes the display options which can only be controlled through the worksheet.
Constructors
Section titled "Constructors"WorksheetDisplayOptions
new WorksheetDisplayOptions(a: Worksheet, b: boolean): WorksheetDisplayOptionsReturns WorksheetDisplayOptions
Properties
Section titled "Properties"$t: TypegridlineColor
Section titled "gridlineColor"Inherited from: DisplayOptions
gridlineColor: anymagnificationInNormalView
Section titled "magnificationInNormalView"magnificationInNormalView: numbermagnificationInPageBreakView
Section titled "magnificationInPageBreakView"magnificationInPageBreakView: numbermagnificationInPageLayoutView
Section titled "magnificationInPageLayoutView"magnificationInPageLayoutView: numberorderColumnsRightToLeft
Section titled "orderColumnsRightToLeft"orderColumnsRightToLeft: booleanpanesAreFrozen
Section titled "panesAreFrozen"Inherited from: DisplayOptions
panesAreFrozen: booleanshowExpansionIndicatorBelowGroupedRows
Section titled "showExpansionIndicatorBelowGroupedRows"Inherited from: DisplayOptions
showExpansionIndicatorBelowGroupedRows: booleanshowExpansionIndicatorToRightOfGroupedColumns
Section titled "showExpansionIndicatorToRightOfGroupedColumns"Inherited from: DisplayOptions
showExpansionIndicatorToRightOfGroupedColumns: booleanshowFormulasInCells
Section titled "showFormulasInCells"Inherited from: DisplayOptions
showFormulasInCells: booleanshowGridlines
Section titled "showGridlines"Inherited from: DisplayOptions
showGridlines: booleanshowOutlineSymbols
Section titled "showOutlineSymbols"Inherited from: DisplayOptions
showOutlineSymbols: booleanshowRowAndColumnHeaders
Section titled "showRowAndColumnHeaders"Inherited from: DisplayOptions
showRowAndColumnHeaders: booleanshowRulerInPageLayoutView
Section titled "showRulerInPageLayoutView"Inherited from: DisplayOptions
showRulerInPageLayoutView: booleanshowWhitespaceInPageLayoutView
Section titled "showWhitespaceInPageLayoutView"showWhitespaceInPageLayoutView: booleanshowZeroValues
Section titled "showZeroValues"Inherited from: DisplayOptions
showZeroValues: booleantabColorInfo
Section titled "tabColorInfo"tabColorInfo: WorkbookColorInfoInherited from: DisplayOptions
view: WorksheetViewvisibility
Section titled "visibility"Inherited from: DisplayOptions
visibility: WorksheetVisibilityAccessors
Section titled "Accessors"frozenPaneSettings
Section titled "frozenPaneSettings"Inherited from: DisplayOptions
Gets the settings which control the frozen panes in the worksheet.
get frozenPaneSettings(): FrozenPaneSettingsReturns FrozenPaneSettings
unfrozenPaneSettings
Section titled "unfrozenPaneSettings"Inherited from: DisplayOptions
Gets the settings which control the unfrozen panes in the worksheet.
get unfrozenPaneSettings(): UnfrozenPaneSettingsReturns UnfrozenPaneSettings
Methods
Section titled "Methods"clearSelection
Section titled "clearSelection"Inherited from: DisplayOptions
Removes any saved selection information.
clearSelection(): voidReturns void
reset
Section titled "reset"Inherited from: DisplayOptions
Resets the display options to their default settings.
reset(): void