Use this 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.
- With your spreadsheet open, from the menu select Spread | Add.
Data in Genstat
Lets you add columns into a spreadsheet from existing data structures in the Genstat server.
from Clipboard
Lets you 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 within the file.
ODBC Data
This allows columns to be added to the spreadsheet from forming an ODBC database query.
ODBC Retrieval
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 a DDE server.
Blank Sheet
This allows a new blank spreadsheet to be added to the current multi-paged book.