New Spreadsheet Options

This dialog provides additional options when a spreadsheet is created either from the clipboard or from opening a CSV file. The display of this dialog can be controlled for when data are copied from the clipboard using the Show New from Clipboard options option within the spreadsheet options. When data are read from the clipboard or a CSV file, if the first row contains text values these will be used as column names in the GenStat spreadsheet, otherwise default column names will be generated (this behaviour can be modified by the options outlined below).

Column names ending in an exclamation mark (!) will have this character removed and the column will be loaded as a factor. Likewise names ending with a dollar ($) or a hash (#) will be loaded as text or variates respectively. Characters in column names that would be invalid as a GenStat identifier name will be converted to underscore (_).

Sort Factor Levels

When selected, columns loaded as factors will have their levels (or labels for a text column) sorted into ascending order.

Suggest Columns to be factors

Prompts to convert columns to factors where the columns have repeated values, and fewer unique values than the specified number given in the Suggest converting columns with <= N unique items option within the spreadsheet options.

Drop Empty rows

Remove any rows from the spreadsheet that contain no data.

Data contains Variates & factors only

Any column containing text will be converted to either a variate or factor. If the number of labels within the spreadsheet column is less than 20%, the column will be made into a variate, otherwise the column will be made into a factor. When reading the column as a variate, common slips such as entering a letter O for the number 0 (or I for 1) will be fixed.

Column Descriptions in Row

When selected, the cells in the specified row number will be used for column descriptions (the EXTRA keyword for GenStat structures).

Read Column names in first row

Where to take the columns names from.

Yes if all labels - if all the cells in the first row contain only labels or are missing, the column name will be from the first row.
Yes - Use the cells in the first row for column names. If the clipboard item contains a number, this is prefixed with a "_" to make it a valid GenStat name.
No - Do not use the first row for column names, but generate all default names.

Add to Book

This provides a list of books that the new spreadsheet can be added to. The default book that spreadsheets are added to can be specified using the Spreadsheet Options - Books menu.