New spreadsheets can be created for entering new data, or loading data from
GenStat or pasting data from the clipboard.
Create a blank spreadsheet
A blank spreadsheet can be created by selecting New | Create from the
Spread menu or New from the
File menu. This opens a dialog where
the spreadsheet type and initial number of rows and columns for the spreadsheet
can be specified. The initial number of rows and columns need not be set to the exact
size required as these can always be extended or removed at a later date.
If a spreadsheet is created as a Vector spreadsheet then the columns within the
spreadsheet will initially be created as variates with the values in each cell set as
missing values. However, the columns can easily
be changed to factors or texts using the right-mouse pop-up menu or the
Spread | Convert menu item.
Data entered into a spreadsheet cannot be used within GenStat until a data
update occurs. By default this occurs automatically when you click within
another window or menu. However, the Update item on the
Spread menu can be used to manually update the data
at any time. To ensure that only the data you have entered are updated within
GenStat the Remove empty rows and cols on save option
can be set within the Column tab of the
spreadsheet options. As with the
automatic updating this option is set by default.
Create a spreadsheet by loading data from GenStat
A spreadsheet can be created by loading data that is currently present in GenStat by
selecting New then Data in GenStat from the
Spread menu. This load menu
lists the data structures that are appropriate for the current setting of the
spreadsheet type. For example, variates, factors and texts are listed for a vector
spreadsheet. Multiple data structures can be loaded into a vector or scalar
spreadsheet, however, matrix, symmetric or diagonal matrix spreadsheets are limited
to single data structures. For table spreadsheets, multiple 1-way tables can be
opened or single tables can be opened for all other types of tables. If any changes are
made to the data within the spreadsheet then these will need to be updated within
within GenStat as outlined in the section for creating a blank spreadsheet.
The FSPREADSHEET procedure can be used to create new spreadsheets within the command language.