Worksheet Display Area

The Bootstrap 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.

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
<dx:BootstrapSpreadsheet ID="SpreadsheetDisplayArea" runat="server" ShowConfirmOnLosingChanges="false"
    OnLoad="SpreadsheetWorksheetDisplayArea_Load">
</dx:BootstrapSpreadsheet>
protected void SpreadsheetWorksheetDisplayArea_Load(object sender, EventArgs e) {
    SpreadsheetDisplayArea.WorksheetDisplayArea.SetSize(0, 6, 20);
}
Screen Size
Color Themes
Demo QR Code
Arial