Workbook and Worksheet Element Protection
DevExpress ASP.NET Spreadsheet Control provides support for worksheet and workbook element protection defined within documents. When the Spreadsheet opens a document that contains protected elements, the control prevents them from being modified by end-users. For instance, the Spreadsheet can lock the workbook’s structure preventing users from adding, deleting, hiding or displaying worksheets. Or, the Spreadsheet can prevent end-users from editing the contents of locked cells within a protected worksheet. This helps obscure data or formulas that might confuse users and prevents them from viewing or making changes to that data.