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
  • Table Name
    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.