Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Worksheet Display Area

  • Undopo
    Undo
  • Cut
    Clipboardpo
    Clipboard
  • v
    v
    po
    po
    po
    po
    Fontpo
    Font
  • Alignment
  • po
    Numberpo
    dialogboxlauncherNumber
  • Cells
  • Editing
  • Styles
  • Propertiespo
    Properties
  • Tools
  • Table Style Optionspo
    Table Style Options
  • Table Style Optionspo
    Table Style Options
  • Layout
  • PivotTable Style Optionspo
    PivotTable Style Options
 


The DevExpress ASP.NET MVC Spreadsheet enables you to programmatically specify the worksheet area that is visible in the Spreadsheet and that allows end-user input.

Use the SetSize method available through the WorksheetDisplayArea property to limit the maximum number of rows and columns to be displayed in a specific sheet. This restricts end-users from accessing worksheet cells through a control's UI. This restriction, however, is not in effect for programmatic cell manipulation so you can change the content and format of each worksheet cell in code.

Note that in this demo the WorksheetDisplayArea property is accessed through the PreRender event's sender object by casting it to the MVCxSpreadsheet type.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos