GrapeCity.Documents.Excel.IWorksheetView

IWorksheetView Interface

Represents worksheet view options.

Provides access to the display settings of a worksheet, such as formula visibility, gridline visibility, reading direction, scroll position, zoom, and view type. Use SheetView to retrieve the view settings for a worksheet.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IWorksheetView

Public Interface IWorksheetView

Examples

IWorksheetView sheetView = worksheet.SheetView;
sheetView.DisplayFormulas = true;
sheetView.DisplayRightToLeft = true;
sheetView.Zoom = 150;

Properties

Name	Description
DisplayFormulas	Gets or sets whether the worksheet displays formulas. Returns `true` if formulas are displayed instead of calculated values, or `false` if the worksheet displays values.
DisplayGridlines	Gets or sets whether gridlines are displayed in the worksheet view. This property indicates whether cell gridlines are currently shown for the worksheet.
DisplayHeadings	Gets or sets whether row and column headings are displayed. Returns whether both row and column headings are visible in the worksheet view.
DisplayHorizontalGridlines	Gets or sets whether horizontal gridlines are displayed. Returns whether horizontal gridlines are visible in the worksheet view.
DisplayOutline	Gets or sets whether outline symbols are displayed. This property indicates whether the worksheet view currently shows outline symbols for grouped rows and columns.
DisplayRightToLeft	Gets or sets whether the worksheet is displayed from right to left instead of from left to right. Returns whether the worksheet view uses right-to-left display.
DisplayRuler	Gets or sets whether a ruler is displayed for the specified worksheet. This property indicates whether the current worksheet view shows the ruler.
DisplayVerticalGridlines	Gets or sets whether vertical gridlines are displayed. Returns whether vertical gridlines are visible in the worksheet view.
DisplayWhitespace	Gets or sets whether whitespace is displayed. This property indicates whether the current worksheet view shows whitespace.
DisplayZeros	Gets or sets whether zero values are displayed in the worksheet view. When this property is `false`, cells whose displayed value is zero are hidden in the current worksheet view.
FitSelection	Gets or sets whether the zoom is set to fit the selection. This option is only supported for Chart.
GridlineColor	Gets or sets the Color object that represents the gridline color of the worksheet.
ScrollColumn	Gets or sets the number of the leftmost column in the pane or worksheet. This value indicates which column is currently displayed at the left edge of the active worksheet view.
ScrollRow	Gets or sets the number of the row that appears at the top of the pane or worksheet. Use this property to determine which row is currently shown at the top edge of the worksheet view.
ViewType	Gets or sets the view type of the worksheet. Use this property to switch the worksheet between different display modes, such as NormalView, PageBreakPreview, and PageLayoutView.
Zoom	Gets or sets the display size of the worksheet as a percentage. A value of `100` represents the normal display size, `200` represents double size, and other values scale the worksheet view accordingly.