The ASP.NET MVC Spreadsheet supports workbook and worksheet element protection defined within a document. If the document contains protected elements, the Spreadsheet prevents their modification by your end-users.
Note: The Formula Bar that displays focused cell content allows end-users to view formulas contained within the protected cells.
In this demo, the Spreadsheet opens a document with the applied worksheet password protection that prevents modification of certain cells. In particular, you can modify only cells belonging to rows from 6 to 22 and columns from D to J - these cells are colored with different shades of green. Using Spreadsheet API, you can allow or disallow end-users to format, insert, delete, sort, filter or edit areas of the protected worksheet. The Protect and Unprotect methods of a worksheet object are used in the demo for this purpose. According to the defined permissions, the Spreadsheet UI prevents end-users from modifying protected elements - ribbon items and context menu items that relate to customization of these elements are either disabled or not in effect.
From a usability standpoint, document protection allows you to hide data or formulas that might confuse end-users and prevent users from viewing or making changes to such data.
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).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos