Spreadsheet Properties

This dialog displays a number of global spreadsheet properties, and a summary of the contents of the spreadsheet columns. To view the spreadsheet properties either select the Properties item on the Sheet submenu of Spread section of the menu bar or double-click on the row column heading.

Type

The type of the spreadsheet: Vector, Matrix, Symmetric Matrix, Diagonal Matrix, Scalar or Table.

Filename

The filename that the spreadsheet was last saved to. If the spreadsheet has not been saved it will have a temporary name based on how it was created. If this filename is changed the next time the spreadsheet is saved it will be saved using this filename.

Sheet Pointers

This is a drop down list containing the name of any pointers associated with the spreadsheet. You can create a pointer to a subset or all columns within a spreadsheet that can then be used in menus and commands.

Structure Name

This is the identifier name for a matrix or 2 dimensional table.

Column Factor

The name of the factor that is used to index the columns within a table.

Read only

Indicates whether the spreadsheet is marked as read only (i.e. protected) so that no data can be changed within it. This can be altered.

Restricted

Indicates whether the data is currently restricted. Uncheck this box to remove a restriction on the spreadsheet.

Saved

Whether the spreadsheet is marked as having been modified since it was last saved.

Modified

Whether the spreadsheet is marked as having been modified since it was last updated to the GenStat server.

Enter moves across rows

Specifies whether the enter key will move the cell focus across the rows as opposed to down the columns.

Active Column/Active Row

The currently active cell in the spreadsheet. Editing this will cause the focus to move to the new cell specified on closing the dialog.

Active Sheet

This indicates whether this is the current active spreadsheet. You can change the status of the sheet using this option.

Selection

Specifies whether there is currently a selection within the spreadsheet.

Column Summary

A list of the columns in the spreadsheet, giving their type, the number of non missing observations (NOBS), and either the minimum, mean and maximum for numeric columns or the number of levels and whether levels & labels are defined for a factor. This information can be copied to the Clipboard by clicking on the Copy button.

Title

Opens a dialog where you can view/edit the spreadsheet title.

Convert

Open a dialog to convert the spreadsheet to another type.