IXlSheet.ViewOptions Property

Provides access to an object that specifies display settings for a worksheet.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.2.Core.dll

Declaration

C#

IXlSheetViewOptions ViewOptions { get; }

VB.NET

ReadOnly Property ViewOptions As IXlSheetViewOptions

Property Value

Type	Description
IXlSheetViewOptions	An IXlSheetViewOptions object that contains worksheet display options.

Remarks

Use the IXlSheetViewOptions object’s members to specify the visibility of gridlines (IXlSheetViewOptions.ShowGridLines), show or hide row and column headers (IXlSheetViewOptions.ShowRowColumnHeaders), show formulas in cells instead of their calculated results (IXlSheetViewOptions.ShowFormulas), display zero values as blank cells (IXlSheetViewOptions.ShowZeroValues), and make outline symbols in an outlined worksheet invisible (IXlSheetViewOptions.ShowOutlineSymbols).

For example, the image below shows the worksheet when gridlines are displayed, and when gridlines are hidden (the workbook is opened in Microsoft® Excel®).

To specify print settings for a worksheet, use the IXlSheet.PrintOptions, IXlSheet.PageSetup and IXlSheet.PageMargins properties.