Gets or sets the color of the gridlines on the worksheet. Syntax Property Value The color of the gridlines on the worksheet. Exceptions Exception Description System.InvalidOperationException The workbook is using a custom palette and setting this color would cause the custom palette to use too many colors. Remarks...
Gets or sets the value which indicates if the panes in the worksheet are frozen. Syntax Property Value The value which indicates if the panes in the worksheet are frozen. Remarks Depending on the value of this property, either the FrozenPaneSettings or the UnfrozenPaneSettings will be used for the worksheet. The u...
Occurs after a property value has changed Syntax Event Data The event handler receives an argument of type PropertyChangedEventArgs containing data related to this event. The following PropertyChangedEventArgs properties provide information specific to this event.Property Description PropertyName
Resets the display options to their default settings. Syntax Remarks The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank worksheet.
Resets the display options to their default settings. Syntax Remarks The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank worksheet.
Gets or sets the value which indicates whether the expansion indicators should be shown below grouped, or indented rows. Syntax
Gets or sets the value which indicates whether the expansion indicators should be shown to the right of grouped, or indented rows. Syntax
Gets or sets the value which indicates whether formulas are shown in cells. Syntax Property Value The value which indicates whether formulas are shown in cells. Remarks If this value is True, the formula string will be displayed in the cell. If the value is False, the result of the formula will be displayed in the...
Gets or sets the value which indicates whether gridlines are shown between cells. Syntax Property Value The value which indicates whether gridlines are shown between cells.
Gets or sets the value which indicates whether outline symbols are shown for outlined columns and rows. Syntax Property Value The value which indicates whether outline symbols are shown for outlined columns and rows. Remarks If the outline symbols are displayed, they provide a visual representation of the outline ...