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.
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:
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:
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.
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: