Select menu: Spread | Add | Data in Genstat
Use this to extend a spreadsheet with new columns containing data from Genstat.
- Click the spreadsheet you want to add columns to so that it has focus then from the menu select Spread | Add | Data in Genstat.
- Select a spreadsheet type.
- Move columns into the Data to load list by double-clicking or by selecting with the mouse and clicking . You can multi-select by holding down Ctrl or Shift then move them all across in one action.
- Click Add to copy the columns to your spreadsheet and close the dialog.
The dialog above shows that two columns will be added to a Vector spreadsheet.
Type of spreadsheet
This indicates the type of the current spreadsheet. You cannot load additional columns to matrix spreadsheets.
Tables in column format
When selected, tables with two or more margins will be added to the spreadsheet within a single column, otherwise if a table has more than two classifying factors the tables will be added as new sheets. If the tables being added do not match those in the current sheet then they will be placed in new sheets. This option does not apply to tables with one dimension.
This lists data structures appropriate for the specified spreadsheet type. You can transfer multiple selections from Available data by holding the Ctrl key on your keyboard while selecting items, then click to move them all across in one action.
Data to load
This lists data structures that have been selected for the spreadsheet. For a vector spreadsheet this will list variates, factors, and texts. Note that the data to be added must have the same number of rows as the current spreadsheet.
Insert blank rows or columns
File New – Spreadsheet
New Spreadsheet from Clipboard
Add data from files
Using Genstat with Excel
Spreadsheet Insert Menu