Spreadsheet Audit Log Viewer

Ribbon bar. Select the Tools tab. In the Tools group, click Audit Trail and from the menu, select View Log to display the Spreadsheet Audit Log Viewer...

Classic menus. From the Tools - Audit Trail submenu, select View Log to display the Spreadsheet Audit Log Viewer...

...which is used to review the changes made to the spreadsheet once logging has been enabled. The log viewer displays a grid of information regarding the audited actions including a sequence number, time of the change, user information, the computer used to make the change, the nature of the change, and (optionally) the reason for the change. Note that column widths in the log grid can be increased and decreased using standard Windows techniques. Following are descriptions of the log entry fields.

Sequence. This field contains a sequence number. The first log entry has a sequence number 1, and each following entry has the next number in sequence. When a log file is truncated (see Spreadsheet Audit Log Settings), this value is reset to 1.

Time Stamp. This field records the system date and time on the local computer at the time the operation occurred. Time is stored in UTC and displayed in local time in the log viewer.

Computer. This field displays the name of the computer on which the operation was performed.

User. This field stores the Windows user name of the logged in user who performed the operation. If the changes are made via Statistica Enterprise Server, the name of the Statistica Enterprise Server user will be displayed here.

Enterprise User. When Statistica Enterprise is installed, this field displays the Statistica Enterprise user name. If the Statistica Enterprise user is an integrated Windows user, this field may be blank because the name in the User field is correct. When Statistica Enterprise is not installed, this field is not displayed in the log viewer.

Category. This field identifies the category of the change such as Data, Document, Case Specs, Headers, Case Selection, etc. See the Spreadsheet Log Table for a complete listing of categories. See also, How Do I Interpret the Spreadsheet Audit Log File.

Action. This field identifies the action that was performed, such as Change Cell, Sort, etc. See the Spreadsheet Log Table for a complete listing of categories.

Old Value. When applicable, this field shows the previous value (e.g., if a cell is changed from 10 to 20, this field will show a 10).

New Value. When applicable, this field shows the new value (e.g., if a cell is changed from 10 to 20, this field will show a 20).

Misc. When applicable, this field contains additional information about the operation (e.g., when the data have been sorted, this field has sort keys and orders).

Reason. If prompting for reasons is enabled, this field contains the reason comment entered by the user. See Spreadsheet Audit Log Settings for more information on requiring user comments for changes.

First Case. When applicable, this field shows the first affected case number (1 based.)

First Var. When applicable, this field shows the first affected variable number (1 based.)

Last Case. When applicable, this field shows the last affected case number (1 based.)

Last Var. When applicable, this field shows the last affected variable number (1 based.)

Output to Spreadsheet. Click this button to copy the log entries to a spreadsheet. Each log entry will be represented as a case in the output spreadsheet. You can use this spreadsheet to view, filter, print, and save the log file. This option is also useful for backing up the existing log file before it is truncated (see Spreadsheet Audit Log Settings for more details on truncating the log file).

OK. Click OK to exit the Spreadsheet Audit Log Viewer.