Spreadsheet Book Options

Open data from GenStat into the current book

When selected, any new sheet that is opened, using the FSPREADSHEET procedure, will by default be added as a new sheet within the book containing the active spreadsheet, or else the current book if there is no active spreadsheet defined. The actual book that FSPREADSHEET adds the sheet to can be set with the BOOK option of FSPREADSHEET, which gives the ranking of the book in the window list (1 = first book, 2 = second book etc). If you want to ensure that a sheet is created in a new book then you can set BOOK=0 and to add subsequent sheets to this book set BOOK=-1.

Open new sheets into the current book

When selected, any new sheet that is opened, will by default be added as a new sheet within the book containing the active spreadsheet, or else the current book if there is no active spreadsheet defined. Alternative books to open sheets within can be selected from a drop down lists (see below) on the menus that are used to create the new spreadsheets.

Open all data files into the current book

When selected, any file part from a GSH or GWB file that is opened, will be added to a new sheet within the book containing the active spreadsheet, or else the current book if there is no active spreadsheet defined.

Update data from all sheets in a book to GenStat

If this option is selected, then when focus moves off the book window, all the sheets in the book will be updated to the server, not just the sheet currently displayed. When this option is selected, GenStat will check that there are no duplicate structure names used in the sheets within the book, as this will cause a clash between structures with the earlier structures being overwritten by the later ones. If there is a duplication, you will be prompted to correct this (shown below), and if this prompt is accepted with the Yes button, the all names will be made to be unique within the book. If the duplicate names are kept, then the current sheet will overwrite any other structures, otherwise the later sheets will over write any earlier sheets structure.

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.

Always warn on duplicate names within a book

If this option is selected, then when a book is opened, or a page is added to a book, and structures exist in different sheets with the same name, you will prompted to correct this (shown above). If this prompt is accepted by clicking Yes, then the names will be changed to make them unique within the book. If this option is not selected and you respond to the prompt by clicking No, then you will not receive this warning again for this book until you add another sheet to the book.

Maximum pages in a book

This sets the maximum pages that will be stored in one book. If you exceed this limit, then the sheets will be opened into a new book. This can be set between 20 and 4000 pages. Reducing this to a reasonable value will reduce the memory overhead for each book. The default setting is 100 pages. If this is changed, the new setting does not take effect until GenStat is restarted.

Open large book files as read only

When selected, any GenStat spreadsheet/book files (GSH and GWB files) that are larger than the specified minimum value will be opened as read only.

Minimum file size for view mode

Any GenStat spreadsheet/book files (GWB and GSH files) larger than the specified file size in megabytes (MB) will be opened as read only.

Defaults

Set the options to their default settings.

Action Buttons

OK	Save the options and close the dialog.
Cancel	Close the dialog without making any changes.