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 and undo commands |
|
Perform grid operations |
|
Controls the display of status bar and windows and resets window positions |
|
Edit, find, format data in the worksheet. Manipulate, transform, and perform calculations with worksheet data. Assign or project coordinates. Track the cursor between the plot, worksheet, and grid windows. |
Not all of the File, Home, Grids, and View commands are available 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 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