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.

<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