Spreadsheet Add Multiple Columns

This dialog can be used to add one or more new columns to a spreadsheet.

Number of Columns

Specifies how many columns to add.

Name Stub

Specifies how to form default names for the new columns. For example, if the name stub is X the new columns will be named X1, X2, and so on. The names can be changed later using the Column Convert from the Spread menu.

Initial Value

Specifies a numeric or textual value that is used to fill each new column. The Column Fill command can be used subsequently to automatically generate sequences or patterns of numbers for the new columns.

Decimal Places Shown

Specifies how many decimal places to display for numeric values.

Where

Specifies whether columns are added before or after the current column, which is indicated on the status bar, or at the start or end of the spreadsheet.

Column Type

This specifies whether the new columns are to be variates or texts. Columns of either type can later be converted to factors, using the right mouse button pop-up menu or the Spread/Factor/Convert To command.