Spreadsheet Control

The TdxSpreadSheet control is designed to work natively with spreadsheet documents using a friendly and familiar cell data editing and processing UI.

UI Elements

The View area displays the currently visible portion of the active worksheet.
The caption bar lists all worksheets in the opened document as named tabs.
Horizontal and vertical scrollbars for the View area. Scrollbar positions and appearance depend on the active scrollbar mode (LookAndFeel.ScrollbarMode). A splitter delimits the caption bar and the horizontal scrollbar located to the right of it in Classic mode. In both Touch and Hybrid modes, the horizontal scrollbar is positioned on top of the caption bar.

Each Spreadsheet area is associated with a built-in context menu containing content-dependent commands.

The automatic UI generation functionality is designed for use together with the Spreadsheet and Formula Bar controls to quickly create a fully functional spreadsheet-based application from scratch as explained in the following topic: How to Create a Ribbon or Toolbar UI for your Spreadsheet-based Application.

Tip

Refer to the TdxSpreadSheet class description for detailed information on all available options.