Example of Protection in ASP.NET MVC Spreadsheet Control

This sample demonstrates protect sheet and protect workbook with EMI calculation scenario as an example. To unprotect the sheet, click the unprotect sheet button in the Data tab. Meanwhile, to unprotect the workbook, click the unprotect workbook button in the data tab and provide the password as spreadsheet in the dialog box.

DEMO

SOURCE

Protect sheet helps you to prevent the users from modifying the data in the spreadsheet. Protect workbook helps you to protect the workbook with a password. In this demo, the `EMI Schedule` sheet is locked using isProtected property inside the `Sheet` property and protect the workbook with a password using password property.

Sheet Protection - Prevents users from modifying locked cells and worksheet content using the isProtected property.
Workbook Protection - Secures the entire spreadsheet with a password using the password property.
Locked Calculations - Ensures formulas and computed results such as EMI values and totals cannot be altered.

More information about protect sheet and lock cell feature can be found in this documentation opens in a new tab section.