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.

Inheritance

Classes that extend this class.

Derived Classes

Inherited from: DisplayOptionsBase

Gets or sets the visibility of the sheet.

public WorksheetVisibility Visibility { get; set; }

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

public FrozenPaneSettings FrozenPaneSettings { get; }

Gets or sets the color of the gridlines on the worksheet.

public Color GridlineColor { get; set; }

Gets or sets the value which indicates if the panes in the worksheet are frozen.

public bool PanesAreFrozen { get; set; }

ShowExpansionIndicatorBelowGroupedRows

Section titled "ShowExpansionIndicatorBelowGroupedRows"

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"

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; }

Gets or sets the value which indicates whether formulas are shown in cells.

public bool ShowFormulasInCells { get; set; }

Gets or sets the value which indicates whether gridlines are shown between cells.

public bool ShowGridlines { get; set; }

Gets or sets the value which indicates whether outline symbols are shown for outlined columns and rows.

public bool ShowOutlineSymbols { get; set; }

Gets or sets the value which indicates whether to display row and column headers.

public bool ShowRowAndColumnHeaders { get; set; }

Gets or sets the value which indicates whether to show rulers in the page layout view.

public bool ShowRulerInPageLayoutView { get; set; }

Gets or sets the value which indicates whether zero values are shown in cells.

public bool ShowZeroValues { get; set; }

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

public UnfrozenPaneSettings UnfrozenPaneSettings { get; }

Gets or sets the current view of the worksheet.

public WorksheetView View { get; set; }

Inherited from: DisplayOptionsBase

Resets the display options to their default settings.

public void Reset()

Returns any

Removes any saved selection information.

public void ClearSelection()

Returns any

Resets the display options to their default settings.

protected override void ResetCore()

Returns any