Analysis Configuration: Data Locking Options

For an Analysis Configuration:

  1. Expand the Spreadsheet options node in the tree view.
  2. Select Locking to display these options.
  3. Use these options to specify locking conditions for the spreadsheet created in Statistica when the Analysis Configuration is run.

You can specify a password to use for unlocking spreadsheets by expanding the System Options node and selecting Spreadsheet.

Spreadsheets are locked on a per-Analysis Configuration basis. For a given Analysis Configuration, if the check boxes in the Data Locking options view are cleared, then the resulting spreadsheet will not be locked even if you have specified a password in the Spreadsheet options view.

Prevent changes to

Use these options to specify the aspects of the spreadsheet that should be locked. When users try to change a locked feature, a message will be displayed informing them that the spreadsheet is locked.

Data

Select the Data check box to prevent changes to the actual data contained in the spreadsheet.

When spreadsheet data are locked, users are unable to change the data values and the missing data code. They will also be unable to perform any data management operations that affect the spreadsheet (such as changing the data type or the length for text variables). If this check box is cleared, users will be able to edit the data (such as by updating queries and spreadsheet formulas or by simply typing in new values).

Display elements (fonts, formats, etc.)

Select the Display elements (fonts, formats, etc.) check box to prohibit the modification of fonts and formats used in the spreadsheet.

When this check box is selected, options for changing the font size, color, type, and style (for instance,  bold or underline) will be unavailable. Additionally, the options for applying spreadsheet layouts (Format - Spreadsheet) will be unavailable.

Case selection and weights

Select the Case selection and weights check box to prevent users from changing case selection conditions and case weights for the locked spreadsheet.

When this option is selected, users will not be able to toggle the use of selection conditions or change the currently defined selection conditions. Most options on the Selection tab of the Spreadsheet Case Selection Conditions dialog box will be unavailable; however, options on the other tabs of that dialog (e.g., creating subsamples, applying formats to selection conditions) may still be available. Options on the Case Weights dialog will also be unavailable.

Variable specifications

Select the Variable specifications check box to prevent changes to the variable specifications (such as measurement type, missing data code, display format, long variable name).

When this check box is selected, users will still be able to view the individual variable specification dialog (accessible by double-clicking the variable name) and the Variable Specifications Editor; however, options for changing these specifications will be dimmed.