Worksheet Document

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:

File

Open and save files, import or export data, print, and set options and defaults

Home

Contains clipboard and undo commands

Grids

Perform grid operations

View

Controls the display of status bar and windows and resets window positions

Data

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 Document

The image below contains the parts of the worksheet document.

 

This is the Surfer worksheet document with the Contents and Properties windows in auto hide mode on
the left, and the plot document and grid node editor tabs at the top of the worksheet.

 

Other Useful Worksheet Information

Worksheet Window

Data File Formats

Opening a Worksheet Window

Working with Worksheet Data

Keyboard Commands

Worksheet Error Codes and Special Numeric Values

Worksheet Statistics

Worksheet Technical Specifications

 

 

See Also

Surfer User Interface

Grid Node Editor

Plot Document