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
 

The DevExpress ASP.NET Spreadsheet (ASPxSpreadsheet) enables you to programmatically specify the worksheet area that is visible in the ASPxSpreadsheet 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.