Class which exposes the worksheet display options which can only be controlled through the custom view.
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; }MagnificationInCurrentView
Section titled "MagnificationInCurrentView"Gets or sets the magnification level of the worksheet in the current .
public int MagnificationInCurrentView { 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()