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.
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
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos |