Column Attributes/Format
See Also
This dialog can be used to change the name of a column or the way its values are displayed. Changes to column attributes only affect the current column, as indicated in the Column list. The column's type and protection is displayed but cannot be changed here.

Column

Selects the column you wish to change attributes for.

Name

Specifies the name of the column. By editing this field you can change the name of the column, and thus the structure that the data will be saved to in GenStat.

Description

This sets additional text appended to the column name in output from some analyses. This has the same effect as the EXTRA parameter in command-mode declarations using VARIATE, FACTOR, TEXT etc.

Decimals

Specifies the number of decimal places for numeric columns in general, scientific or fixed-point format. The interpretation of decimals depends on the format chosen. For fixed format it is the number of decimal places and for general and scientific format it is the number of significant figures to be displayed.

Width

Specifies the width of the column as the number of 'average characters'. This will be an exact number of characters for fixed-width fonts, but only approximate for proportionally spaced fonts.

Display Table Headings as Levels

Show the levels of the factor indexing columns in a 2+ dimensional table, rather than labels.

Calculation

The formula used to calculate a column. This can be edited and then may be rerun using the Recalculate Column dialog.

Minimum

A number specifying the minimum value that the column will accept. If you try and enter a number smaller than this, a warning will be provided. You can still force the smaller number to be entered into the spreadsheet cell. A missing value (*) specifies no minimum value constraint.

Maximum

A number specifying the maximum value that the column will accept. If you try and enter a number larger than this, a warning will be provided. You can still force the larger number to be entered into the spreadsheet cell. A missing value (*) specifies no maximum value constraint.

Maximum width of text in Output

For a text or factor, this limits the width of the strings printed in the Output window to the specified value. This can be used to make printed tables or columns more succinct.

Reference Level

For a factor, a particular level is used in the parameterization of regression models as the base level. The effects of the other factor levels are then defined as differences from this base or reference level. This drop down list of the factors current levels allows this to be set to a particular level. The option Default specifies the first level or the factor, and if the factor levels are reordered, the new first level will become the reference level. If a particular level has been chosen as a reference level, the spreadsheet will attempt to always make this the reference level on any operations that reorder the factor levels.

Identifying information used in output

This controls the information that is used to identify data structures in output. For data structures that use a whole sheet (e.g. matrices or tables) this must be set on the first column of the spreadsheet containing the data (e.g. not classifying factors for a table or row labels for a matrix). This option has the same effect as using the the IPRINT setting for the data structures directives: VARIATE, TEXT, FACTOR, SCALAR, TABLE, MATRIX, SYMMETRICMATRIX and DIAGONALMATRIX.

The options that can be selected are:

DefaultUse the standard information for data structures for each type of output. For example, printing data structures in the output will use the column name, and running an analysis of variance will produce both the column name and description in the output (if description is set).
IdentifierUse the column name.
ExtraUse the extra text. You can provide extra text within the Description field.

Data Verified

An informational note to indicate data if this column has been verified through a double entry process. See Verify Data in Spreadsheet for more details.

OK

Make the changes to the column and close the dialog.

Apply

Make the changes to the column and leave the dialog open to edit another column's attributes.

Cancel

Close the dialog without making any further changes.

Sheet

Can be used to edit global spreadsheet properties using the Spreadsheet Properties dialog.

Convert

Can be used to change the type of a column or spreadsheet using the Convert dialog.

Fill

Can be used to insert values in a column using the Spreadsheet Column Fill dialog.

Justification

Specifies whether values should be right or left justified or centred. Default justification is left for text and right for numeric data.

Numeric Format

Specifies the format used for displaying numeric columns. General format prints numbers in the most compact format for a given number of significant figures, fixed format uses fixed-point notation, and scientific format prints numbers in scientific notation (e.g. 1.7665E+6 = 1.7665 x 10**6 = 1766500).

Date format is available to display numbers in a date format chosen with the Date type button. The default date format applied to a column is set using the Date Format tab opened from the Tools | Options menu.

Date type

This can be used to change the date format and base date used to display a column's values when the numerical format type Date is selected. This uses the Date Formats dialog.

Display Factor as

Controls how factors are displayed: using ordinals, levels, or labels. Factor values are stored as ordinals which are integers in the range 1,2,...,n, where n is the number of levels of the factor. Factors are displayed using the ordinal values unless levels or labels have been defined. Factor levels are a set of numbers, one for each ordinal level, used for display of the factor values. Factor labels are a set of strings, one for each ordinal level, used for display of the factor values.

Levels & Labels

Can be used to edit factor levels, labels and colours all in one place with the Edit Factor Levels and Labels dialog. This is the simplest way of editing all factor attributes in one place.

Levels

Can be used to edit just the factor levels with the Edit Factor Levels dialog.

Labels

Can be used to edit just the factor labels with the Edit Factor Labels dialog.

Reorder

Can be used to change the order factor levels/labels are displayed in using the Reorder Factor Levels dialog.

Colour using Factor

Can be used to change the background column of the cells in a column using the colours associated with a factor column in a spreadsheet. The colours associated with a factors levels are set with the Edit Factor Levels and Labels dialog. This item is not displayed unless some factors in the spreadsheet have colours associated with it's levels. If there are factors with colours these factors will be displayed in the drop-down list. Selecting the item <None> will turn off the cell colouring for this column.

See Also

Edit Multiple Column Attributes
Edit Factor Levels and Labels
Edit Factor Levels
Edit Factor Labels
Converting columns to other types.
Column Protection
Edit Menu Commands (Spreadsheet)
Spreadsheet Calculate Menu
Options - Date Format
Spreadsheet Column Menu
Spreadsheet Properties