GrapeCity.Documents.Excel.IWorksheetView

Interface IWorksheetView

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents worksheet view options.

public interface IWorksheetView

Properties

DisplayFormulas

Gets or sets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values.

bool DisplayFormulas { get; set; }

Property Value

bool

DisplayGridlines

Gets or sets whether gridlines are displayed. When this is set, DisplayVerticalGridlines and DisplayHorizontalGridlines would be set to same value.

bool DisplayGridlines { get; set; }

Property Value

bool

DisplayHeadings

Gets or sets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).

bool DisplayHeadings { get; set; }

Property Value

bool

DisplayHorizontalGridlines

Gets or sets whether horizontal gridlines are displayed. When this is set false, DisplayGridlines would be false, too.

bool DisplayHorizontalGridlines { get; set; }

Property Value

bool

DisplayOutline

Gets or sets whether outline symbols are displayed.

bool DisplayOutline { get; set; }

Property Value

bool

DisplayRightToLeft

Gets or sets whether the specified worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right).

bool DisplayRightToLeft { get; set; }

Property Value

bool

DisplayRuler

Gets or sets whether a ruler is displayed for the specified worksheet (read or write).

bool DisplayRuler { get; set; }

Property Value

bool

DisplayVerticalGridlines

Gets or sets whether vertical gridlines are displayed. When this is set false, DisplayGridlines would be false, too.

bool DisplayVerticalGridlines { get; set; }

Property Value

bool

DisplayWhitespace

Gets or sets whether whitespace is displayed (read or write).

bool DisplayWhitespace { get; set; }

Property Value

bool

DisplayZeros

Gets or sets whether zero values are displayed.

bool DisplayZeros { get; set; }

Property Value

bool

GridlineColor

Returns or sets the GrapeCity.Documents.Excel.RGBColor object that represents the gridline color of the worksheet.

Color GridlineColor { get; set; }

Property Value

System.Drawing.Color

ScrollColumn

Returns or sets the number of the leftmost column in the pane or worksheet.

int ScrollColumn { get; set; }

Property Value

int

ScrollRow

Returns or sets the number of the row that appears at the top of the pane or worksheet.

int ScrollRow { get; set; }

Property Value

int

ViewType

Gets and sets the view type.

ViewType ViewType { get; set; }

Property Value

ViewType

Zoom

Returns or sets a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on).

int Zoom { get; set; }

Property Value

int