This example demonstrates how to use the WorksheetDisplayArea.SetSize method to restrict the number of rows and columns the SpreadsheetControl displays in a worksheet.
In particular, the code snippet below shows how to set the active worksheet's visible area to the used range the Worksheet.GetUsedRange method returns.
| C# |
Worksheet worksheet = spreadsheetControl.ActiveWorksheet;
Range usedRange = worksheet.GetUsedRange();
spreadsheetControl.WorksheetDisplayArea.SetSize(worksheet.Index, usedRange.ColumnCount, usedRange.RowCount);
|
| VB |
Dim worksheet As Worksheet = spreadsheetControl.ActiveWorksheet
Dim usedRange As Range = worksheet.GetUsedRange()
spreadsheetControl.WorksheetDisplayArea.SetSize(worksheet.Index, usedRange.ColumnCount, usedRange.RowCount)
|
The following image shows the result:
