Skip to main content

SpreadsheetViewOptions Members

Provides access to a set of display settings of the SpreadsheetControl.

Constructors

Name Description
SpreadsheetViewOptions() Initializes a new instance of the SpreadsheetViewOptions class with the default settings.

Properties

Name Description
BackColor Gets or sets the SpreadsheetControl’s background color when a worksheet’s visible area is restricted.
Charts Gets options specific to chart display in the SpreadsheetControl.
ColumnHeaderHeight Gets or sets the height of the column headers in pixels.
Pictures Provides access to options specific for displaying pictures in the spreadsheet.
RowHeaderWidth Gets or sets the width of the row headers in pixels.
ShowColumnHeaders Gets or sets a value indicating whether column headers are displayed in the SpreadsheetControl.
ShowPlaceholders Gets or sets whether to display placeholders for unsupported document elements (charts, slicers, ActiveX controls, and SmartArt graphics).
ShowPrintArea Gets or sets whether the printable area of the worksheet is displayed with a dashed border.
ShowRowHeaders Gets or sets a value indicating whether row headers are displayed in the SpreadsheetControl.
UseFontSubstitution Gets or sets whether to use font substitution to display characters that are missing in the current font.

Methods

Name Description
Assign(BaseOptions) Copies all settings from the options object passed as a parameter. Inherited from BaseOptions.
BeginUpdate() Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions.
CancelUpdate() Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions.
EndUpdate() Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string representing the currently enabled options. Inherited from BaseOptions.
See Also