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
object
Classes that extend this class.
Derived ClassesProperties
Section titled "Properties"Visibility
Section titled "Visibility"Inherited from: DisplayOptionsBase
Gets or sets the visibility of the sheet.
public WorksheetVisibility Visibility { get; set; } FrozenPaneSettings
Section titled "FrozenPaneSettings"Gets the settings which control the frozen panes in the worksheet.
public FrozenPaneSettings FrozenPaneSettings { get; } GridlineColor
Section titled "GridlineColor"Gets or sets the color of the gridlines on the worksheet.
public Color GridlineColor { get; set; } PanesAreFrozen
Section titled "PanesAreFrozen"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; } ShowFormulasInCells
Section titled "ShowFormulasInCells"Gets or sets the value which indicates whether formulas are shown in cells.
public bool ShowFormulasInCells { get; set; } ShowGridlines
Section titled "ShowGridlines"Gets or sets the value which indicates whether gridlines are shown between cells.
public bool ShowGridlines { get; set; } ShowOutlineSymbols
Section titled "ShowOutlineSymbols"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"Gets or sets the value which indicates whether to display row and column headers.
public bool ShowRowAndColumnHeaders { get; set; } ShowRulerInPageLayoutView
Section titled "ShowRulerInPageLayoutView"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"Gets or sets the value which indicates whether zero values are shown in cells.
public bool ShowZeroValues { get; set; } UnfrozenPaneSettings
Section titled "UnfrozenPaneSettings"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; } Methods
Section titled "Methods"Reset()
Section titled "Reset()"Inherited from: DisplayOptionsBase
Resets the display options to their default settings.
public void Reset() Returns any
ClearSelection()
Section titled "ClearSelection()"Removes any saved selection information.
public void ClearSelection() Returns any
ResetCore()
Section titled "ResetCore()"Resets the display options to their default settings.
protected override void ResetCore()