.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

DocumentOptions.ZoomMode Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

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

Property Value

Type Description
WorksheetZoomMode

One of the WorksheetZoomMode enumeration values specifying the zoom mode.

The default is WorksheetZoomMode.AllViews.

Property Value

Type Description
WorksheetZoomMode

One of the WorksheetZoomMode enumeration values specifying the zoom mode.

The default is WorksheetZoomMode.AllViews.

Property Value

Type Description
WorksheetZoomMode

One of the WorksheetZoomMode enumeration values specifying the zoom mode.

The default is WorksheetZoomMode.AllViews.

Remarks

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;
Note

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

See Also