A ribbon contains multiple tabs with grouped commands that enable users to perform basic operations in the Spreadsheet control: create, load, modify, save, and print spreadsheet documents.
See how to add a ribbon to the Spreadsheet application.
The Formula Bar displays an active cell's value and allows users to view, enter, and edit Formulas and cell data in the Spreadsheet control.
See how to add the Formula Bar to the Spreadsheet application.
Use the following API to control the visibility of the Formula Bar's elements:
The Name Box is a part of the Formula Bar that displays a reference to an active cell or a name for the selected cell range (if specified), picture or chart. The Name Box also enables users to create named ranges, and quickly navigate to cells by their references and names.
Worksheet
A worksheet is a single page within a document. A worksheet is represented by a grid of cells and is used to store and edit data in the Spreadsheet control. The default Spreadsheet application contains one blank worksheet.
The Worksheet.ActiveView property provides access to options that specify a worksheet's appearance in the Spreadsheet control:
Rows and Columns
Each worksheet is divided into 1,048,576 rows and 16,384 columns. Each row is numbered (1, 2, 3, ...) and each column is lettered (A, B, C, ...) or numbered (1, 2, 3, ...), depending on the reference style applied.
Use the following API to set the row height and column width and customize the appearance of row and column headers:
Specify the Display Area
The Spreadsheet control displays all columns and rows. You can call the WorksheetDisplayArea.SetSize method to restrict the number of visible columns and rows.
Freeze Rows or Columns
The Worksheet.FreezeRows, Worksheet.FreezeColumns, and Worksheet.FreezePanes methods enable you to keep specific rows and columns visible when a user scrolls a worksheet. See the How to: Freeze and Unfreeze Rows and Columns example for details.
Cells
All worksheet data is stored in cells. All cells have faint borders, or gridlines, around them. The WorksheetView.ShowGridlines property allows you to show or hide gridlines.
Use the SpreadsheetControl.GetCellBounds method to obtain a cell's coordinates and size.
Edit Cells
Users can double-click a cell, press F2 or start typing to edit a cell value. They can enter a numeric or text value, or insert a formula to calculate a cell's value dynamically. You can assign a custom in-place editor to a cell to facilitate user input.
Cell Appearance
Use the following API to format cells in a worksheet:
Selection
The Spreadsheet control enables users to select cells, cell ranges, rows, and columns in a worksheet. The selected cell used to enter data is called an active cell. Use the SpreadsheetControl.ActiveCell property to obtain the active cell. When a cell range is selected, the active cell is usually the top left cell of this range.
Use the following API to specify selection in code:
Selection Options
The SpreadsheetControl.Options.Behavior.Selection property provides access to the following selection options:
Sheet Tab Selector
The Sheet Tab Selector displays all worksheets in a workbook. It enables users to add new worksheets, move between the existing worksheets, rename, hide or delete them.
Vertical and Horizontal Scroll Bars
The horizontal and vertical scroll bars allow users to navigate through the current worksheet.
Context Menus
When a user right-clicks anywhere on a worksheet (that is, a cell, row or column header, picture or chart), a context menu appears. It contains basic commands used to work with the current object.
See the list of available context menu types.
Dialogs
The WinForms Spreadsheet ships with a number of dialogs that enable users to load documents, format cells, insert functions, create charts, tables, and pivot tables, specify print settings, and so on.
See the list of Spreadsheet dialogs.
A status bar appears at the bottom of the Spreadsheet application and displays the following elements:
-
Summary data: the average, count, numerical count, min, max, and sum of selected cells.
-
The zoom level and zoom slider.
See how to add a status bar to the Spreadsheet application.