officefileapi-devexpress-dot-spreadsheet-dot-sheetview.md
Returns or specifies the zoom percentage for a sheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
int Zoom { get; set; }
Property Zoom As Integer
| Type | Description |
|---|---|
| Int32 |
The zoom percentage.
|
This example demonstrates how to zoom a worksheet view (Worksheet.ActiveView). To do this, set the WorksheetView.Zoom property to an integer value that specifies the required zoom factor for a worksheet view.
Note
To specify how a worksheet should be scaled when it is printed, use the WorksheetPrintOptions.Scale property of the object accessed via Worksheet.PrintOptions. Refer to the How to: Specify Print Settings document for details on how to specify print options for a worksheet.
// Zoom in the worksheet view.
workbook.Worksheets[0].ActiveView.Zoom = 150;
' Zoom in the worksheet view.
workbook.Worksheets(0).ActiveView.Zoom = 150
The DocumentOptions.ZoomMode property specifies whether the zoom percentage applies to all worksheet views (WorksheetZoomMode.AllViews) or the current view only (WorksheetZoomMode.ActiveView).
Note
The WinForms, WPF and ASP.NET Spreadsheet controls can display the Normal worksheet view only.
The following code snippets (auto-collected from DevExpress Examples) contain references to the Zoom property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
// Zoom in to the worksheet view.
workbook.Worksheets[0].ActiveView.Zoom = 150;
#endregion #WorksheetZoom
// Zoom in to the worksheet view.
workbook.Worksheets[0].ActiveView.Zoom = 150;
#endregion #WorksheetZoom
// Zoom in the worksheet view.
workbook.Worksheets[0].ActiveView.Zoom = 150;
#endregion #WorksheetZoom
' Zoom in to the worksheet view.
workbook.Worksheets(0).ActiveView.Zoom = 150
' #End Region ' #WorksheetZoom
' Zoom in to the worksheet view.
workbook.Worksheets(0).ActiveView.Zoom = 150
' #End Region ' #WorksheetZoom
' Zoom in the worksheet view.
workbook.Worksheets(0).ActiveView.Zoom = 150
#End Region ' #WorksheetZoom
See Also