Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Material
Material Compact
Office 365
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 Spreadsheet (ASPxSpreadsheet) enables you to programmatically specify the worksheet area that is visible in the ASPxSpreadsheet 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.

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
Arial