1. Home
  2. Spreadsheet Add Menu

Spreadsheet Add Menu

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.

  1. 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.

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.

See also

Updated on May 3, 2019

Was this article helpful?