.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

DocumentOptions.ZoomMode Property

Gets or sets a zoom mode for all worksheets in the document.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll


public WorksheetZoomMode ZoomMode { get; set; }
Public Property ZoomMode As WorksheetZoomMode

Property Value

Type Description

One of the WorksheetZoomMode enumeration values specifying the zoom mode.

The default is WorksheetZoomMode.AllViews.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to ZoomMode
WinForms Controls SpreadsheetControl
Office File API ISpreadsheetComponent


The ZoomMode property allows you to specify how to apply the zoom setting defined by the WorksheetView.Zoom property to a worksheet. You can specify the zoom percentage for all worksheet views (Normal, Page Layout, and Page Break Preview) at once or for the current view only (Worksheet.ActiveView). The ZoomMode property is set to WorksheetZoomMode.AllViews by default.

To specify an individual zoom percentage for each worksheet view, set the ZoomMode property to WorksheetZoomMode.ActiveView, and then define the necessary zoom settings. Use the WorksheetView.ViewType property to switch between the worksheet views.

Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
// Set the document's zoom mode to ActiveView
// to specify an individual zoom percentage for each worksheet view.
workbook.Options.ZoomMode = WorksheetZoomMode.ActiveView;
// Specify the zoom level for the Page Break Preview.
worksheet.ActiveView.ViewType = WorksheetViewType.PageBreakPreview;
worksheet.ActiveView.Zoom = 90;
// Specify the zoom level for the Page Layout view.
worksheet.ActiveView.ViewType = WorksheetViewType.PageLayout;
worksheet.ActiveView.Zoom = 110;
// Specify the zoom level for the Normal view.
worksheet.ActiveView.ViewType = WorksheetViewType.Normal;
worksheet.ActiveView.Zoom = 120;

The current versions of the WinForms, WPF and ASP.NET spreadsheet controls display the Normal worksheet view only.

See Also