IXlSheet.ViewOptions Property
Provides access to an object that specifies display settings for a worksheet.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.1.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
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.