ContextQMD
Back to Devexpress

How to: Zoom In and Out of a Worksheet

officefileapi-12405-spreadsheet-document-api-examples-worksheets-how-to-zoom-in-and-out-of-a-worksheet.md

latest1.8 KB
Original Source

How to: Zoom In and Out of a Worksheet

  • Sep 19, 2023

Important

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these examples in production code.

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.

View Example

csharp
// Zoom in the worksheet view. 
workbook.Worksheets[0].ActiveView.Zoom = 150;
vb
' Zoom in the worksheet view. 
workbook.Worksheets(0).ActiveView.Zoom = 150

The image below shows the result (the workbook is opened in Microsoft® Excel®).