DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.IWorksheetView

IWorksheetView Interface

Represents worksheet view options.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IWorksheetView

Public Interface IWorksheetView

Properties

Name	Description
DisplayFormulas	Gets or sets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values.
DisplayGridlines	Gets or sets whether gridlines are displayed. When this is set, DisplayVerticalGridlines and DisplayHorizontalGridlines would be set to same value.
DisplayHeadings	Gets or sets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).
DisplayHorizontalGridlines	Gets or sets whether horizontal gridlines are displayed. When this is set false, DisplayGridlines would be false, too.
DisplayOutline	Gets or sets whether outline symbols are displayed.
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).
DisplayRuler	Gets or sets whether a ruler is displayed for the specified worksheet (read or write).
DisplayVerticalGridlines	Gets or sets whether vertical gridlines are displayed. When this is set false, DisplayGridlines would be false, too.
DisplayWhitespace	Gets or sets whether whitespace is displayed (read or write).
DisplayZeros	Gets or sets whether zero values are displayed.
FitSelection	Gets or sets whether the zoom is set to fit the selection. Unlike Microsoft Excel Application, this option does not modify the value of the Zoom property. This option is only supported for Chart.
GridlineColor	Returns or sets the GrapeCity.Documents.Excel.RGBColor object that represents the gridline color of the worksheet.
ScrollColumn	Returns or sets the number of the leftmost column in the pane or worksheet.
ScrollRow	Returns or sets the number of the row that appears at the top of the pane or worksheet.
ViewType	Gets and sets the view type.
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).