The Options command in the View menu allows the user to set options concerning the display of the spreadsheet. The options are machine dependent, thus the settings will be consistent across files opened on the same machine, but will not be carried to a new machine by simply copying a file. When exiting the Options dialog by selecting OK, any changes made are immediately accepted and applied to the spreadsheet. When the application is exited, the options are updated in the computer’s registry.
General options may be examined/modified by clicking the Options command on the View menu and selecting the General tab. The General tab contains an option for the initial path to open documents.
The first time the Open or Admin Open commands are used, the Open dialog will display this folder. By default, this option is set to the "C:\My Experiments" folder. This option may be changed by entering a new folder, or by using the Browse button to select a folder.
The spreadsheet options may be examined/modified by clicking the Options command on the View menu and selecting the Spreadsheet tab. The Spreadsheet tab contains options for font size, column header for multi-level variables, and inheritance.
The Font Size is the display size of the text in the spreadsheet cells. By default, the font size is 8. To make the font size larger (10, 12, or 14), click the arrow to display the drop-down list and select the new font size.
Column Header for Multi-Level Variables
E-Prime data files allow a variable to occur at more than one level. These variables are called multi-level variables, and the spreadsheet contains a column for that variable for each level of its occurrence. For example, if the variable "Color" occurs at both the block and trial level, the spreadsheet will contain two columns for that variable: "Color[Block]" and "Color[Trial]". The first column will contain the values logged at the block level, and the second column will contain the values logged at the trial level. Column headers for multi-level variables may be displayed with the level name or the level number in brackets after the variable name. By default, the level name is used. To change this, select the level number option. For example, "Color[Block]" and "Color[Trial]" can be displayed as "Color" and "Color" (assuming block is level two and trial is level three for this example).
The Inheritance option allows the user to toggle the inheritance feature within E-DataAid on or off. By default, this feature is on. When the inheritance option is on, any multi-level variable cell that has missing data will inherit its data value from the variable’s next highest level. For example, if a variable occurs at two levels (e.g., Color occurs at both the Block and Trial levels), the spreadsheet will have two columns for that variable (e.g., Color[Block]and Color[Trial]). When inheritance is on, any cells containing missing values in the lower level for the variable (e.g., Trial) will inherit the value from the next higher level (e.g., Block). Inherited values are displayed in italics to alert the user that the value has been inherited. When inheritance is off, the cell would contain NULL to indicate missing data.
Figure 1: Inheritance turned on Figure 2: Inheritance turned off
Edit options may be examined/modified by clicking the Options command on the View menu and selecting the Edits tab. The Edits tab contains options for color and annotation prompts.
By default, the spreadsheet displays all edited values in red. To change the color of edits to either green or blue, click the arrow to display the drop-down list and select the new color.
For all modifications to a data file, the application automatically writes an annotation to the file. An annotation records the time and date of the edit, the original value, and the modified value. User comments may be added to annotations. By default, the application does not prompt the user to enter comments when edits are made (i.e., the Annotations Prompt box is unchecked). This option may be enabled by clicking the Annotations Prompt box to check it. Comments may be added at any time using the Display Annotations command on the View menu.
Filters options may be examined/modified by clicking the Options command on the View menu and selecting the Filters tab. The Filters tab contains an option for displaying values in the drop-down lists on the Range filter.
The Range filter contains fields that allow the selection of values from a drop-down list to include in the filter. By default, the Range filter displays the first 32,767 unique values of a variable. Uncheck this option to prevent the values from being displayed. In large files, because of the time required to process these unique values, it may be advisable to disable this option to reduce processing time when using the Range filter. When this option is unchecked, it is still possible to enter filter values by typing a value in the field rather than selecting it from the list. This option does not affect the checklist filter that always displays the first 32,767 unique values.