Version

Setting the Worksheet Zoom Level (Infragistics Excel Engine)

Topic Overview

Purpose

This topic explains how to programmatically set the zoom level on a worksheet.

Required background

The following topics are prerequisites to understanding this topic:

Topic Purpose

In this section you will find information that will help you to better understand the object model and the functionalities of the Infragistics Excel Engine.

In this topic

This topic contains the following sections:

Introduction

Zooming summary

The worksheet allows you to control the magnification (zooming) level.

Zoom Level Configuration Summary

Headers configuration summary chart

The following table explains briefly the configurable aspects of the worksheet’s zooming.

Configurable aspect Details Property/Command

Sets the worksheet’s zoom level at a specific value.

Setting the Zoom Level

Overview

You can change the zoom for each worksheet independently using the MagnificationInNormalView property on the DisplayOptions object. This property takes a value between 10 and 400.

Property settings

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And set it to:

Change zoom level

MagnificationInNormalView

To an int type value between 10 and 400.

Example

The following code snippet demonstrates how to set the zoom level to 150%.

In C#:

workbook1.Worksheets[0].DisplayOptions.MagnificationInNormalView = 150;

Related Content

Topics

The following topics provide additional information related to this topic.

Topic Purpose

This topic explains how to show or hide the gridlines and set their color.

This topic explains how to show or hide the column and row headers.

This topic explains how to prevent the user from editing the cell values in a worksheet.