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

Worksheet Display Area

  • Undo
    Redo
    Undopo
    Undo
  • Paste
    Cut
    Copy
    Clipboardpo
    Clipboard
  • v
    v
    po
    po
    po
    po
    Fontpo
    Font
  • Wrap Text
    Merge Cellspo
    Alignmentpo
    Alignment
  • po
    Numberpo
    dialogboxlauncherNumber
  • Insertpo
    Deletepo
    Formatpo
    Cellspo
    Cells
  • AutoSumpo
    Fillpo
    Clearpo
    Sort & Filterpo
    Find
    Editingpo
    Editing
  • Format as Table
    Stylespo
    Styles
  • Propertiespo
    Properties
  • Convert to Range
    Toolspo
    Tools
  • Table Style Optionspo
    Table Style Options
  • Modify Style
    Table Style Optionspo
    Table Style Options
  • Subtotalspo
    Grand Totalspo
    Report Layoutpo
    Blank Rowspo
    Layoutpo
    Layout
  • PivotTable Style Optionspo
    PivotTable 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.

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
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos

Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).
All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.