Worksheet Protection

The Bootstrap Spreadsheet control supports workbook and worksheet element protection defined within a document. If the document contains protected elements, 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.

A
B
C
D
E
F
G
H
I
J
K
L
M
N
XFE
XFE
1
2
3
4
5
6
7
12
13
15
17
18
19
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Expense Category
Expenses
Jan
Feb
Mar
Apr
May
Jun
Total
Employee Costs
Benefits
$22,950
$22,950
$22,950
$23,760
$23,760
$23,760
$140,130
Marketing Costs
Collateral preparation
$4,800
$0
$0
$5,500
$0
$0
$10,300
Marketing Costs
Marketing events
$1,800
$2,200
$2,200
$4,700
$1,500
$2,300
$14,700
Office Costs
Office lease
$9,800
$9,800
$9,800
$9,800
$9,800
$9,800
$58,800
Office Costs
Security
$600
$600
$600
$600
$600
$600
$3,600
Training/Travel
Training classes
$1,600
$2,400
$1,400
$1,600
$1,200
$2,800
$11,000
Training/Travel
Training-related travel costs
$1,200
$2,200
$1,400
$1,200
$800
$3,500
$10,300
Employee Costs
Wages
$85,000
$85,000
$85,000
$88,000
$88,000
$88,000
$519,000
Marketing Costs
Web site hosting
$500
$500
$500
$500
$500
$500
$3,000
Marketing Costs
Web site updates
$220
$230
$280
$280
$220
$1,900
$3,130
Total
$128,470
$125,880
$124,130
$135,940
$126,380
$133,160
$773,960
Detailed Expense Estimates
These columns are not locked
These rows are not locked
<dx:BootstrapSpreadsheet ClientInstanceName="Spreadsheet" runat="server" ActiveTabIndex="0"
    ShowConfirmOnLosingChanges="false">
</dx:BootstrapSpreadsheet>
Screen Size
Color Themes
Demo QR Code
Calibri