Spreadsheet Restrict/Filter Menu

The Restrict/Filter submenu on the Spread menu contains a number of commands for controlling GenStat data restrictions. A restriction, also known as filter in other applications such as Microsoft Excel, can be used to subset the data displayed for use in menus and graphics. When data are restricted in a spreadsheet only the rows included in the restriction are updated to the GenStat server. Therefore, rows excluded from the restriction will be not be included in any subsequent analysis, thus, providing a way of analysing a subset of data without having to make a copy of the data containing just the required rows.

Restrictions can be applied to matrices and tables within a spreadsheet, however, these structures cannot be restricted within the GenStat server. If the Subset on Update option is selected, then a reduced matrix or table with restricted rows removed will be sent to the server.

Display Restricted Rows

When selected, any rows that have been excluded from the restriction will have the row number and contents displayed in red. This just provides a visual indication of the restriction and values can still be selected or modified. If this option is not selected, then the rows excluded from the retriction will be hidden from view.

Subset on Update

When selected, the update menu items on the Spread menu 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.

By Logical Expression

Allows you to create a restriction by specifying a logical expression.

To Groups (factor levels)

Allows you to create a restriction using factor grouping.

By Value

Allows you to create a restriction using a simple expression.

Selected Rows

Add or remove the selected rows to the current restriction.

Set as Excluded rows	The selected rows will be set to be the excluded rows.
Combined with Excluded rows	The selected rows will be added to the excluded rows.
Remove from Excluded rows	The selected rows will be removed from the excluded rows.

Unselected Rows

Add or remove the unselected rows to the current restriction.

Set as Excluded rows	The unselected rows will be set to be the excluded rows.
Combined with Excluded rows	The unselected rows will be added to the excluded rows.
Remove from Excluded rows	The unselected rows will be removed from the excluded rows.

Save/Apply...

Allows you to save the current spreadsheet restriction or apply a previously saved restriction. This opens the Save Restriction/Filter dialog.

Bookmarked Rows

Add bookmarked rows to the current restriction.

Include only	The bookmarked rows will be set to be the included rows.
Exclude	The bookmarked rows will be added to the excluded rows.

Duplicate Rows

Filter the displayed rows to only display the rows which have duplicate values. This opens the Restrict/Filter Duplicate Rows dialog.

Values equal to current Cell

Using the values in the current column, any row not containing the same value as the current cell is excluded from the restriction set. This combines the restriction of including only values equal to the current cell with any current restriction in place.

Exclude rows with Missing values

Any row containing a missing value (*) is excluded from the restriction set.

Include only rows with Missing values

The rows in the restriction set (i.e. included) is set to just those rows containing at least one missing value (*).

Reverse Exclusion/Inclusion

The rows currently excluded are set as included, and vice-versa.

Remove All

Removes any existing restriction/filter.