Zooming In or Out On the Worksheet in GridDesktop

Sometimes, when working with your data, you may want to enlarge the contents on the screen without actually changing the font size. For instance, you may have formatted your text so that it uses a small font. (This is often necessary to get all your information on a printout.) When working in the worksheet, however, the font is difficult to read because it is so small.

In Microsoft Excel, a zoom slider is available for zooming in and out of documents quickly and easily. The zoom slider is usually in the lower right corner of the software window.

Aspose.Cells also allows developers to set the worksheet’s zoom factor, so the contents should be appeared as per your desired percentage value.

Zooming In or Out Using Aspose.Cells.GridDesktop

Aspose.Cells provides Aspose.Cells.GridDesktop.Worksheet class that has a wide range of properties and methods for managing worksheets. To set a worksheet’s zoom factor, use the Worksheet class' Zoom property. The zoom factor is set by assigned a numeric (integer) value to the Zoom property.

We build an MS Excel like zoom slider using TrackBar (.NET) control. In a WinForm project, we place the Aspose.Cells.GridDesktop control from Toolbox to the form and specify some properties to set its name, size or other aspects accordingly. Now, we place the TrackBar control @ lower right corner below the GridDesktop control, we also put a Label control that would show the percentage value you specify via TrackBar control’s handle. We add relative lines of code in TrackBar’s Scroll event, so when you scroll the Trackbar control, GridDesktop should zoom in or out to show the data/ contents in it.

A complete example is given below that demonstrates how to use the Zoom property to set the zoom factor of the active worksheet of GridDesktop. We first import a template Excel file to GridDesktop.

Write below code in the Load event of form to set the template Excel file in GridDesktop and trackbar value.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Importing the template Excel file to GridDesktop
gridDesktop1.ImportExcelFile(dataDir + "EmployeeSales.xlsx");

// Set the default value of the TrackBar control
trackBar1.Value = 100;

// Set the custom label's text to the trackbar's value for display
label1.Text = trackBar1.Value.ToString() + "%";

Now copy below code inside track scroll event and run the application. You will notice that moving track bar will change the zoom property of worksheet.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Set the Zoom factor of the active worksheet to the Trackbar's value
gridDesktop1.Worksheets[gridDesktop1.GetActiveWorksheet().Index].Zoom = trackBar1.Value;

// Show the percentage value of the specified Zoom
label1.Text = trackBar1.Value.ToString() + "%";