Spreadsheet Update Menu

Changed data to GenStat

Selecting this menu item will submit any data that has been changed in a spreadsheet to the GenStat server. The first time this is selected all the data on a spreadsheet is submitted to the server; data structures are created for the appropriate data using either the column names (for Vector or Scalar spreadsheets), or the spreadsheet name. Note that this will overwrite any existing data structures that have the same name. Subsequent use of this item will send only those values that have been modified since the previous update occurred.

By default the updating of data is set to happen automatically whenever another menu or window is activated. This behaviour is controlled using options the File tab of the spreadsheet options. Note: that in normal use the updating of data happens automatically whenever the mouse is moved away from a spreadsheet and another menu or window activated. This default behaviour can be disabled using the Spreadsheet Options menu.

Note that if any existing UNITS command has been set using the command language, then this will be lost when a spreadsheet is updated. If a spreadsheet contains a units column this will be used to specify the units, otherwise any previous units command is cancelled. If the FSPREADSHEET procedure is used, it will detect any units structure if this is the same length as the columns in a Vector spreadsheet.

All Data to GenStat

This will submit all the data from a spreadsheet to the GenStat server.

Auto Update GenStat

When selected, any changed data is automatically updated in the GenStat server when another menu or window is activated. The default behaviour for automatically updating the GenStat server can be set using the Auto Update GenStat option on the File tab of the spreadsheet options.

Refresh Sheet from GenStat

If data structures contained within a spreadsheet have been re-calculated using other menus or GenStat commands you can select this item to refresh the spreadsheet with those changes. Selecting this item generates an FSPREADSHEET statement that updates the spreadsheet with the data.

Auto Refresh Sheet from GenStat

When selected, data structures contained within a spreadsheet are updated whenever changes have been made to the data using other menus or GenStat commands. The default behaviour for automatically refreshing data in a spreadsheet can be set using the Auto Refresh from GenStat option on the File tab of the spreadsheet options.

Using fast load (Save & Close)

Allows you to update data to the GenStat Server using the fast load facility. By default, the data are submitted to the GenStat Server by constructing a series of READ statements. For large spreadsheets this results in a large number of commands being generated and can be time consuming to load. The fast load option provides a faster method for updating data where a SPLOAD command is submitted as opposed to READ statements.

Changed data in Book to GenStat

Selecting this menu item will submit any data that has been changed within a multi-paged spreadsheet book to the GenStat server. The first time this is selected all the data within the book is submitted to the server.

All Book to GenStat

This will submit all the data from a multi-paged spreadsheet book to the GenStat server. When multiple sheets are updated to the server, the sheets are updated in the following order: Scalars, Vectors, Matrices, Symmetric Matrices, Diagonal Matrices and Tables. The current sheet will be the last sheet updated for a particular type, for example, if the current sheet is a Vector sheet this will be updated in the server after all the other Vector sheets, but before any Matrix sheets.

Subset on Update

When selected, the update menu items will only submit a subset of the data based on any restriction that has been applied. If any rows have been restricted then these will be submitted to the GenStat server creating a (unrestricted) subset including just those rows. Any factors updated in this way will have any unused levels/labels excluded so, for example, they will not appear in tables of means etc. Any change to data in the restricted rows will enforce a update of all the columns in the spreadsheet to the GenStat server. When this option is activated the row numbers are displayed in yellow to indicate this mode.