Back to Devexpress

Access the Spreadsheet Editor Controls

expressappframework-400894-document-management-office-module-access-spreadsheet-editor-controls.md

latest1.9 KB
Original Source

Access the Spreadsheet Editor Controls

  • Feb 16, 2026

This topic describes how to access and customize the SpreadsheetControl control used to display Spreadsheet documentsin XAF Windows Forms applications with the Office Module:

Note

XAF does not support the Spreadsheet editor for ASP.NET Core Blazor applications.

Access the WinForms-Specific Control (SpreadsheetControl)

Follow the steps below to access the SpreadsheetControl and restrict the number of visible rows and columns in a worksheet.

  1. Create a custom ViewController in the WinForms application project (MySolution.Win).
  2. In the overridden OnActivated method, get the SpreadsheetServiceController and subscribe to its CustomizeSpreadsheetControl event.
  3. In the CustomizeSpreadsheetControl‘s handler, access the SpreadsheetControl and subscribe to its DocumentLoaded event.
  4. In the DocumentLoaded event handler, use the SetSize method to specify the number of visible rows and columns for an active worksheet.

See Also

Customize the Spreadsheet Editors