Select menu: Spread | Update
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 on the Tools | Spreadsheet Options | Sheets tab by selecting/deselecting Auto update Genstat. 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.
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.
Changed data to Genstat and Close Sheet
This will submit any data in the spreadsheet that has changed since the last update to the Genstat server (as decribed above) and then close the spreadsheet window. You will be prompted to save any changes if the spreadsheet has been modified.
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. This behaviour is controlled on the Tools | Spreadsheet Options | Sheets tab by selecting/deselecting Auto update Genstat.
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. This behaviour is controlled on the Tools | Spreadsheet Options | Sheets tab by selecting/deselecting Auto refresh sheet from Genstat.
Using fast load (Save & Close)
Lets you 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.