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.
See Also