Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Web
  [Expand]DevExpress.Web.ASPxGauges
  [Expand]DevExpress.Web.ASPxGauges.Base
  [Expand]DevExpress.Web.ASPxGauges.Scripts
  [Expand]DevExpress.Web.ASPxHtmlEditor
  [Expand]DevExpress.Web.ASPxHtmlEditor.Localization
  [Expand]DevExpress.Web.ASPxHtmlEditor.Scripts
  [Expand]DevExpress.Web.ASPxPivotGrid
  [Expand]DevExpress.Web.ASPxPivotGrid.Data
  [Expand]DevExpress.Web.ASPxPivotGrid.HtmlControls
  [Expand]DevExpress.Web.ASPxPivotGrid.Scripts
  [Expand]DevExpress.Web.ASPxRichEdit
  [Expand]DevExpress.Web.ASPxRichEdit.Localization
  [Expand]DevExpress.Web.ASPxRichEdit.Scripts
  [Expand]DevExpress.Web.ASPxScheduler
  [Expand]DevExpress.Web.ASPxScheduler.Commands.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Controls
  [Expand]DevExpress.Web.ASPxScheduler.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Drawing
  [Expand]DevExpress.Web.ASPxScheduler.Localization
  [Expand]DevExpress.Web.ASPxScheduler.Reporting
  [Expand]DevExpress.Web.ASPxScheduler.Scripts
  [Expand]DevExpress.Web.ASPxSpellChecker
  [Expand]DevExpress.Web.ASPxSpellChecker.Localization
  [Expand]DevExpress.Web.ASPxSpellChecker.Scripts
  [Collapse]DevExpress.Web.ASPxSpreadsheet
   [Expand]ASPxSpreadsheet Class
   [Expand]ASPxSpreadsheetLoadingPanelSettings Class
   [Expand]ASPxSpreadsheetSettingsBase Class
    InitializeDocumentEventHandler Delegate
    SaveFileDialogDisplaySectionMode Enumeration
   [Expand]SpreadsheetClientSideEvents Class
   [Expand]SpreadsheetDialogFormSettings Class
   [Expand]SpreadsheetDialogSettings Class
   [Expand]SpreadsheetDocumentSelectorCommonSettings Class
   [Expand]SpreadsheetDocumentSelectorSettings Class
   [Expand]SpreadsheetFileManagerCommonSettings Class
   [Expand]SpreadsheetFileManagerEditingSettings Class
   [Expand]SpreadsheetFileManagerFoldersSettings Class
   [Expand]SpreadsheetFileManagerUploadSettings Class
   [Expand]SpreadsheetFileManagerValidationSettings Class
   [Expand]SpreadsheetFormsSettings Class
   [Expand]SpreadsheetFormulaAutoCompeteStyles Class
   [Expand]SpreadsheetFormulaBarButtonImageProperties Class
   [Expand]SpreadsheetFormulaBarButtonSectionStyles Class
   [Expand]SpreadsheetFormulaBarStyles Class
   [Expand]SpreadsheetImages Class
   [Expand]SpreadsheetInitializeDocumentEventArgs Class
   [Expand]SpreadsheetInsertLinkDialogSettings Class
   [Expand]SpreadsheetInsertPictureDialogSettings Class
   [Expand]SpreadsheetRibbonContextTabCategoryCollection Class
    SpreadsheetRibbonMode Enumeration
   [Expand]SpreadsheetRibbonTabCollection Class
   [Expand]SpreadsheetSaveFileDialogSettings Class
   [Collapse]WorksheetDisplayArea Class
     WorksheetDisplayArea Members
     WorksheetDisplayArea Constructor
    [Collapse]WorksheetDisplayArea Methods
     [Expand]GetColumnCount Method
     [Expand]GetRowCount Method
     [Expand]Reset Method
     [Collapse]SetSize Method
       SetSize(String, Int32, Int32) Method
       SetSize(Int32, Int32, Int32) Method
  [Expand]DevExpress.Web.ASPxSpreadsheet.Localization
  [Expand]DevExpress.Web.ASPxSpreadsheet.Scripts
  [Expand]DevExpress.Web.ASPxTreeList
  [Expand]DevExpress.Web.ASPxTreeList.Internal
  [Expand]DevExpress.Web.ASPxTreeList.Localization
  [Expand]DevExpress.Web.ASPxTreeList.Scripts
  [Expand]DevExpress.Web.Captcha
  [Expand]DevExpress.Web.Data
  [Expand]DevExpress.Web.Internal
  [Expand]DevExpress.Web.Localization
  [Expand]DevExpress.Web.Mvc
  [Expand]DevExpress.Web.Mvc.BinderSettings
  [Expand]DevExpress.Web.Mvc.Controllers
  [Expand]DevExpress.Web.MVC.Scripts
  [Expand]DevExpress.Web.Mvc.UI
  [Expand]DevExpress.Web.Office
  [Expand]DevExpress.Web.Office.Internal
  [Expand]DevExpress.Web.Rendering
  [Expand]DevExpress.Web.Scripts
  [Expand]DevExpress.XtraCharts.Web
  [Expand]DevExpress.XtraCharts.Web.Designer
  [Expand]DevExpress.XtraCharts.Web.Scripts
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

WorksheetDisplayArea.SetSize(String, Int32, Int32) Method

Defines the number of visible columns and rows for the specified worksheet.

Namespace:DevExpress.Web.ASPxSpreadsheet
Assembly:DevExpress.Web.ASPxSpreadsheet.v17.2.dll

Expanded Syntax

Parameters

worksheetName
Type: String
A string value specifying the name of the worksheet whose visible area should be restricted.
maxColumnCount
Type: Int32
An integer that represents the maximum number of columns to be displayed in a worksheet.
maxRowCount
Type: Int32
An integer that represents the maximum number of rows to be displayed in a worksheet.

Expanded Remarks

The following example demonstrates how to display only 6 columns and 20 rows in a worksheet.

The image below shows the result.

Note that the SetSize method does not affect API methods, so you can change cell content and formatting in code.

To restore the restricted visible area to the default size with all rows and columns visible, use the Reset method.

Expanded See Also

How would you rate this topic?​​​​​​​