ExcelViewOptions Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Stores MS Excel display and view related options.

public sealed class ExcelViewOptions
Public NotInheritable Class ExcelViewOptions
Inheritance:
System.Object
ExcelViewOptions

Properties

Dpi

Gets or sets the DPI (dots or pixels per inch) at which the workbook should be rendered.

public static double Dpi { get; set; }
Public Shared Property Dpi As Double
Property Value
System.Double

The DPI at which the workbook should be rendered.

Remarks

The Dpi also affects how DevicePixel is converted from and to other LengthUnits.

The Dpi should be updated whenever the DPI changes for a Per Monitor DPI Aware application.

FirstVisibleColumn

Index of the first visible column in the worksheet.

public int FirstVisibleColumn { get; set; }
Public Property FirstVisibleColumn As Integer
Property Value
System.Int32
Remarks

Default value for this property is 0.

FirstVisibleRow

Index of the first visible row in the worksheet.

public int FirstVisibleRow { get; set; }
Public Property FirstVisibleRow As Integer
Property Value
System.Int32
Remarks

Default value for this property is 0.

OutlineColumnButtonsRight

Gets or sets whether outline column buttons are displayed on the right side of groups.

public bool OutlineColumnButtonsRight { get; set; }
Public Property OutlineColumnButtonsRight As Boolean
Property Value
System.Boolean
Remarks

This property is simply written to Excel file and has no effect on behavior of this library. For more information on worksheet protection, consult Microsoft Excel documentation.

See Also

OutlineRowButtonsBelow

Gets or sets whether outline row buttons are displayed below groups.

public bool OutlineRowButtonsBelow { get; set; }
Public Property OutlineRowButtonsBelow As Boolean
Property Value
System.Boolean
Remarks

This property is simply written to Excel file and has no effect on behavior of this library. For more information on worksheet protection, consult Microsoft Excel documentation.

See Also

PageBreakViewZoom

Magnification factor in page break view.

public int PageBreakViewZoom { get; set; }
Public Property PageBreakViewZoom As Integer
Property Value
System.Int32
Remarks

Unit is one percent. Value must be between 10 and 400.

Default value for this property is 60.

Exceptions
System.ArgumentOutOfRangeException

Value is out of 10 to 400 range.

ShowColumnsFromRightToLeft

If true, MS Excel shows columns from right to left.

public bool ShowColumnsFromRightToLeft { get; set; }
Public Property ShowColumnsFromRightToLeft As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is false.

ShowFormulas

If true, MS Excel shows formulas. Otherwise, formula results are shown.

public bool ShowFormulas { get; set; }
Public Property ShowFormulas As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is false.

ShowGridLines

If true, MS Excel shows grid lines.

public bool ShowGridLines { get; set; }
Public Property ShowGridLines As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is true.

ShowInPageBreakPreview

If true, MS Excel shows worksheet in page break preview. Otherwise, normal view is used.

public bool ShowInPageBreakPreview { get; set; }
Public Property ShowInPageBreakPreview As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is false.

This value is supported only for XLSX and XLSB files.

ShowOutlineSymbols

If true, MS Excel shows outline symbols.

public bool ShowOutlineSymbols { get; set; }
Public Property ShowOutlineSymbols As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is true.

ShowSheetHeaders

If true, MS Excel shows row and column headers.

public bool ShowSheetHeaders { get; set; }
Public Property ShowSheetHeaders As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is true.

ShowZeroValues

If true, MS Excel shows zero values. Otherwise, zero values are shown as empty cells.

public bool ShowZeroValues { get; set; }
Public Property ShowZeroValues As Boolean
Property Value
System.Boolean
Remarks

Default value for this property is true.

ViewType

Gets and sets the view type.

public ViewType ViewType { get; set; }
Public Property ViewType As ViewType
Property Value
ViewType
Remarks

Default value for this property is ViewType.

ViewType is supported only for XLSX and XLSB files.

Zoom

Magnification factor in normal view.

public int Zoom { get; set; }
Public Property Zoom As Integer
Property Value
System.Int32
Remarks

Unit is one percent. Value must be between 10 and 400.

Default value for this property is 100.

Exceptions
System.ArgumentOutOfRangeException

Value is out of 10 to 400 range.