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

Worksheet Display Area

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
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
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
  • Undopo
    Undo
  • Cut
    Clipboardpo
    Clipboard
  • v
    v
    po
    po
    po
    po
    Fontpo
    Font
  • Alignment
  • po
    Numberpo
    dialogboxlauncherNumber
  • Cells
  • Editing
  • Styles
  • Propertiespo
    Properties
  • Tools
  • Table Style Optionspo
    Table Style Options
  • Table Style Optionspo
    Table Style Options
  • Layout
  • PivotTable Style Optionspo
    PivotTable Style Options
A
B
C
D
E
F
XFE
XFE
XFE
XFE
XFE
XFE
XFE
XFE
XFE
XFE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
1048577
Purchase price
$19,700
Down payment
$1,000
Trade-in value
$500
Interest rate
3.10%
Length of loan (in months)
60
Monthly payment
($327.84)
Vehicle Payment Calculator
Total cost
$21,170.37
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 DevExpress ASP.NET MVC Spreadsheet enables you to programmatically specify the worksheet area that is visible in the Spreadsheet and that allows end-user input.

Use the SetSize method available through the WorksheetDisplayArea property to limit the maximum number of rows and columns to be displayed in a specific sheet. This restricts end-users from accessing worksheet cells through a control's UI. This restriction, however, is not in effect for programmatic cell manipulation so you can change the content and format of each worksheet cell in code.

Note that in this demo the WorksheetDisplayArea property is accessed through the PreRender event's sender object by casting it to the MVCxSpreadsheet type.

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
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos