Worksheets
Worksheet windows are a view of the data file and are designed to display, edit, enter, and save data. The worksheet windows have several useful and powerful editing, transformation, and statistical operations available. In addition, a coordinate system can be assigned to the data file. Several import and export options are available for opening data files from other spreadsheet programs. The components of the worksheet window are displayed below.
Worksheet Commands
The worksheet commands include commands on the following tabs:
|
Open and save files, import or export data, print, and set options and defaults |
|
|
Contains clipboard, undo, and selection commands. |
|
|
Perform grid operations directly from the worksheet data. |
|
|
Controls the display of the status bar, windows, and cursor tracking between the plot, worksheet, and grid windows |
|
|
Edit, find, and format data in the worksheet. Use this tab to manipulate, transform, and perform calculations with worksheet data, as well as assign or project coordinates. |
NOTE : The File, Home, Grids, and View tabs are context-sensitive. Not all commands available in the Plot window will be available when working in the Worksheet view.
The Application/Document Control menu commands control the size and position of the application window or the document window.
Tab View
The plot, worksheet, and grid node editor windows are displayed as tabbed documents. When more than one window is open, tabs appear at the top of the document, allowing you to click on a tab to switch to a different window. The tabs may be dragged to reorder them. When a document contains unsaved changes, an asterisk (*) appears next to its tabbed name. The asterisk is removed once the changes have been saved.
Worksheet Window
The following image and table explain the purpose of the Worksheet window components. To enter data in a worksheet, click the File | Open in Worksheet command to open an existing data file or click the File | New | Worksheet command to create a blank worksheet. The components of the worksheet window are discussed below.
|
|
|
The components of a worksheet window shown above are described in the table below. |
|
Component |
Function |
|
The letter that identifies a column of the worksheet. |
|
|
The number that identifies a row of the worksheet. |
|
|
The cell highlighted with a bold outline. The active cell receives data input (numeric values or text strings) from the keyboard. Only one cell is active at a time. |
|
|
The location of the active cell, specified by column letter and row number. |
|
|
The box displaying the data or text contained in the active cell. Data typed into an empty cell appears in both the edit box and the active cell. |
|
|
The name of the data file displayed in the worksheet or the worksheet number prior to saving. |
|
|
The button used to select all cells in the worksheet. Located in the top left corner of the worksheet. |
Other Useful Worksheet Information
Worksheet Error Codes and Special Numeric Values
Worksheet Technical Specifications