Spreadsheet Add Menu

This menu can be used to insert columns from other data sources into a spreadsheet or add a new blank sheet to the current multi-paged book. For adding columns, the data source must contain data that is compatible with the current spreadsheet. For example, it must have the same number of rows as the spreadsheet. An alternative facility for copying columns from other open spreadsheets can be found within the Column Menu.

Data in GenStat

Allows you to add columns into a spreadsheet from existing data structures in the GenStat server.

from Clipboard

Allows you to add the data from the clipboard into the spreadsheet as a set of new columns.

Data File

This allows columns to be added to the spreadsheet from an external data file. GenStat supports a wide range of data file formats. If the file type is unknown then GenStat will read the file and try determine its format based on the details witin the file.

ODBC Data Query

This allows columns to be added to the spreadsheet from forming an ODBC database query.

ODBC Retreival

This allows columns to be added to the spreadsheet from a GenStat saved ODBC query (GDE) file.

DDE Link

This allows columns to be added to the spreadsheet from from a DDE server.

Blank Sheet

This allows a new blank spreadsheet to be added to the current multi-paged book.