Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Worksheet Protection

H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
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
40
41
42
43
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
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
Actions allowed in the protected worksheet:
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

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


See Also:
Collapse/Expand
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
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos
Calibri