Class SheetView
Represents the sheet view class used by the spreadsheet model.
Inherited Members
Namespace: DRIT.Spreadsheet
Assembly: DRIT.Spreadsheet.dll
Syntax
public class SheetView
Constructors
SheetView(Sheet)
Initializes a new SheetView for the supplied workbook data.
Declaration
public SheetView(Sheet sheet)
Parameters
| Type | Name | Description |
|---|---|---|
| Sheet | sheet |
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 |
|---|---|
| int |
Pane
Exposes the pane associated with SheetView.
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 |
|---|---|
| bool |
ShowFormulas
Flag indicating whether this sheet should display formulas.
Declaration
public bool ShowFormulas { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
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 |
|---|---|
| bool |
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 |
|---|---|
| bool |
ShowRowColumnHeaders
Flag indicating whether the sheet should display row and column headings.
Declaration
public bool ShowRowColumnHeaders { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
ShowRuler
Show the ruler in Page Layout View.
Declaration
public bool ShowRuler { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
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 |
|---|---|
| bool |
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 |
|---|---|
| bool |
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 |
|---|---|
| bool |
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 |
|---|---|
| bool |
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 |
|---|---|
| int |
ZoomScaleNormal
Zoom magnification to use when in normal view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.
Declaration
public int ZoomScaleNormal { get; set; }
Property Value
| Type | Description |
|---|---|
| int |
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 |
|---|---|
| int |