Class SheetView

Inheritance

System.Object

SheetView

WorksheetView

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class SheetView : object

Constructors

SheetView(Sheet)

Declaration

public SheetView(Sheet sheet)

Parameters

Type	Name	Description
Sheet	sheet

Fields

DefaultDefaultGridColor

Declaration

public const bool DefaultDefaultGridColor = null

Field Value

Type	Description
System.Boolean

DefaultFormulasVisible

Declaration

public const bool DefaultFormulasVisible = null

Field Value

Type	Description
System.Boolean

DefaultGridLinesVisible

Declaration

public const bool DefaultGridLinesVisible = null

Field Value

Type	Description
System.Boolean

DefaultOutlineSymbolsVisible

Declaration

public const bool DefaultOutlineSymbolsVisible = null

Field Value

Type	Description
System.Boolean

DefaultRightToLeft

Declaration

public const bool DefaultRightToLeft = null

Field Value

Type	Description
System.Boolean

DefaultRowColumnHeadersVisible

Declaration

public const bool DefaultRowColumnHeadersVisible = null

Field Value

Type	Description
System.Boolean

DefaultRulerVisible

Declaration

public const bool DefaultRulerVisible = null

Field Value

Type	Description
System.Boolean

DefaultTabSelected

Declaration

public const bool DefaultTabSelected = null

Field Value

Type	Description
System.Boolean

DefaultWhiteSpaceVisible

Declaration

public const bool DefaultWhiteSpaceVisible = null

Field Value

Type	Description
System.Boolean

DefaultWindowProtection

Declaration

public const bool DefaultWindowProtection = null

Field Value

Type	Description
System.Boolean

DefaultWorkbookViewId

Declaration

public const int DefaultWorkbookViewId = null

Field Value

Type	Description
System.Int32

DefaultZerosVisible

Declaration

public const bool DefaultZerosVisible = null

Field Value

Type	Description
System.Boolean

DefaultZoomScale

Declaration

public const int DefaultZoomScale = null

Field Value

Type	Description
System.Int32

DefaultZoomScaleNormal

Declaration

public const int DefaultZoomScaleNormal = null

Field Value

Type	Description
System.Int32

DefaultZoomScalePageLayoutView

Declaration

public const int DefaultZoomScalePageLayoutView = null

Field Value

Type	Description
System.Int32

DefaultZoomScaleSheetLayoutView

Declaration

public const int DefaultZoomScaleSheetLayoutView = null

Field Value

Type	Description
System.Int32

Properties

GridlineColor

Index to the color value for row/column text headings and gridlines. This is an 'index color value' (ICV) rather than rgb value.

Declaration

public SpreadsheetColor GridlineColor { get; set; }

Property Value

Type	Description
SpreadsheetColor

PageBreakPreviewZoomScale

Zoom magnification to use when in page break preview, representing percent values. This attribute is restricted to values ranging from 10 to 400.

Declaration

public int PageBreakPreviewZoomScale { get; set; }

Property Value

Type	Description
System.Int32

Pane

Declaration

public Pane Pane { get; set; }

Property Value

Type	Description
Pane

RightToLeft

Flag indicating whether the sheet is in 'right to left' display mode. When in this mode, Column A is on the far right, Column B ;is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format.

Declaration

public bool RightToLeft { get; set; }

Property Value

Type	Description
System.Boolean

ShowFormulas

Flag indicating whether this sheet should display formulas.

Declaration

public bool ShowFormulas { get; set; }

Property Value

Type	Description
System.Boolean

Remarks

When True custom column widths will not be visible.

ShowGridLines

Flag indicating whether this sheet should display gridlines.

Declaration

public bool ShowGridLines { get; set; }

Property Value

Type	Description
System.Boolean

ShowOutlineSymbols

Flag indicating whether the sheet has outline symbols visible. This flag shall always override SheetPr element's outlinePr child element whose attribute is named showOutlineSymbols when there is a conflict.

Declaration

public bool ShowOutlineSymbols { get; set; }

Property Value

Type	Description
System.Boolean

ShowRowColumnHeaders

Flag indicating whether the sheet should display row and column headings.

Declaration

public bool ShowRowColumnHeaders { get; set; }

Property Value

Type	Description
System.Boolean

ShowRuler

Show the ruler in Page Layout View.

Declaration

public bool ShowRuler { get; set; }

Property Value

Type	Description
System.Boolean

ShowWhiteSpace

Flag indicating whether page layout view shall display margins. False means do not display left, right, top (header), and bottom (footer) margins (even when there is data in the header or footer).

Declaration

public bool ShowWhiteSpace { get; set; }

Property Value

Type	Description
System.Boolean

ShowZeros

Flag indicating whether the window should show 0 (zero) in cells containing zero value. When false, cells with zero value appear blank instead of showing the number zero.

Declaration

public bool ShowZeros { get; set; }

Property Value

Type	Description
System.Boolean

TabSelected

Flag indicating whether this sheet is selected. When only 1 sheet is selected and active, this value should be in synch with the activeTab value. In case of a conflict, the Start Part setting wins and sets the active sheet tab.

Declaration

public bool TabSelected { get; set; }

Property Value

Type	Description
System.Boolean

ViewType

Indicates the view type.

Declaration

public SheetViewType ViewType { get; set; }

Property Value

Type	Description
SheetViewType

WindowProtection

Flag indicating whether the panes in the window are locked due to workbook protection. This is an option when the workbook structure is protected.

Declaration

public bool WindowProtection { get; set; }

Property Value

Type	Description
System.Boolean

ZoomScale

Window zoom magnification for current view representing percent values. This attribute is restricted to values ranging from 10 to 400.

Declaration

public int ZoomScale { get; set; }

Property Value

Type	Description
System.Int32

ZoomScaleNormal

Declaration

public int ZoomScaleNormal { get; set; }

Property Value

Type	Description
System.Int32

ZoomScalePageLayoutView

Zoom magnification to use when in page layout view, representing percent values. This attribute is restricted to values ranging from 10 to 400.

Declaration

public int ZoomScalePageLayoutView { get; set; }

Property Value

Type	Description
System.Int32