Class which exposes the display options which can only be controlled through the worksheet.
Inheritance
Properties
Section titled "Properties"FrozenPaneSettings
Section titled "FrozenPaneSettings"Inherited from: DisplayOptions
Gets the settings which control the frozen panes in the worksheet.
public FrozenPaneSettings FrozenPaneSettings { get; }GridlineColor
Section titled "GridlineColor"Inherited from: DisplayOptions
Gets or sets the color of the gridlines on the worksheet.
public Color GridlineColor { get; set; }PanesAreFrozen
Section titled "PanesAreFrozen"Inherited from: DisplayOptions
Gets or sets the value which indicates if the panes in the worksheet are frozen.
public bool PanesAreFrozen { get; set; }ShowExpansionIndicatorBelowGroupedRows
Section titled "ShowExpansionIndicatorBelowGroupedRows"Inherited from: DisplayOptions
Gets or sets the value which indicates whether the expansion indicators should be shown below grouped, or indented rows.
public ExcelDefaultableBoolean ShowExpansionIndicatorBelowGroupedRows { get; set; }ShowExpansionIndicatorToRightOfGroupedColumns
Section titled "ShowExpansionIndicatorToRightOfGroupedColumns"Inherited from: DisplayOptions
Gets or sets the value which indicates whether the expansion indicators should be shown to the right of grouped, or indented rows.
public ExcelDefaultableBoolean ShowExpansionIndicatorToRightOfGroupedColumns { get; set; }ShowFormulasInCells
Section titled "ShowFormulasInCells"Inherited from: DisplayOptions
Gets or sets the value which indicates whether formulas are shown in cells.
public bool ShowFormulasInCells { get; set; }ShowGridlines
Section titled "ShowGridlines"Inherited from: DisplayOptions
Gets or sets the value which indicates whether gridlines are shown between cells.
public bool ShowGridlines { get; set; }ShowOutlineSymbols
Section titled "ShowOutlineSymbols"Inherited from: DisplayOptions
Gets or sets the value which indicates whether outline symbols are shown for outlined columns and rows.
public bool ShowOutlineSymbols { get; set; }ShowRowAndColumnHeaders
Section titled "ShowRowAndColumnHeaders"Inherited from: DisplayOptions
Gets or sets the value which indicates whether to display row and column headers.
public bool ShowRowAndColumnHeaders { get; set; }ShowRulerInPageLayoutView
Section titled "ShowRulerInPageLayoutView"Inherited from: DisplayOptions
Gets or sets the value which indicates whether to show rulers in the page layout view.
public bool ShowRulerInPageLayoutView { get; set; }ShowZeroValues
Section titled "ShowZeroValues"Inherited from: DisplayOptions
Gets or sets the value which indicates whether zero values are shown in cells.
public bool ShowZeroValues { get; set; }UnfrozenPaneSettings
Section titled "UnfrozenPaneSettings"Inherited from: DisplayOptions
Gets the settings which control the unfrozen panes in the worksheet.
public UnfrozenPaneSettings UnfrozenPaneSettings { get; }Inherited from: DisplayOptions
Gets or sets the current view of the worksheet.
public WorksheetView View { get; set; }Visibility
Section titled "Visibility"Inherited from: DisplayOptionsBase
Gets or sets the visibility of the sheet.
public WorksheetVisibility Visibility { get; set; }MagnificationInNormalView
Section titled "MagnificationInNormalView"Gets or sets the magnification level of the worksheet when it is displayed in normal view.
public int MagnificationInNormalView { get; set; }MagnificationInPageBreakView
Section titled "MagnificationInPageBreakView"Gets or sets the magnification level of the worksheet when it is displayed in the page break preview.
public int MagnificationInPageBreakView { get; set; }MagnificationInPageLayoutView
Section titled "MagnificationInPageLayoutView"Gets or sets the magnification level of the worksheet when it is displayed in page layout view.
public int MagnificationInPageLayoutView { get; set; }OrderColumnsRightToLeft
Section titled "OrderColumnsRightToLeft"Gets or sets the value indicating whether the columns are ordered right to left.
public bool OrderColumnsRightToLeft { get; set; }ShowWhitespaceInPageLayoutView
Section titled "ShowWhitespaceInPageLayoutView"Gets or sets the value which indicates whether to show whitespace between worksheet pages in page layout view.
public bool ShowWhitespaceInPageLayoutView { get; set; }TabColorInfo
Section titled "TabColorInfo"Gets or sets the to use for the associated worksheet's tab in the tab bar of Microsoft Excel.
public WorkbookColorInfo TabColorInfo { get; set; }Methods
Section titled "Methods"ClearSelection()
Section titled "ClearSelection()"Inherited from: DisplayOptions
Removes any saved selection information.
public void ClearSelection()Returns any
Reset()
Section titled "Reset()"Inherited from: DisplayOptionsBase
Resets the display options to their default settings.
public void Reset()Returns any
ResetCore()
Section titled "ResetCore()"Resets the display options to their default settings.
protected override void ResetCore()