Spreadsheet Log Table

The following log entries can be posted to the spreadsheet log file. The fields shown in this table are a subset of the fields that are shown in the Spreadsheet Audit Log Viewer. For a description of the other fields, see Spreadsheet Audit Log Viewer.

Note that audit logs of spreadsheets are maintained on a per spreadsheet basis. To track changes to a specific spreadsheet, open the spreadsheet and from the Tools – Audit Trail submenu, select Settings. The Spreadsheet Audit Log Settings dialog box will be displayed, and you can enable logging for the spreadsheet.

Use this table to review the specific information recorded in the log entry for each spreadsheet operation. If a field is empty, no information is stored in the field for that particular operation.

 

Operation

CATEGORY

ACTION

MISC

FC

FV

LC

LV

OLD

NEW

File Create

Document

Create

 

 

 

 

 

 

 

Import Excel, SPSS, Text, SAS, etc.

Document

Import

File name of imported file

 

 

 

 

 

 

Truncate Log

Document

Log Truncated

 

 

 

 

 

 

 

Enable/Disable Logging

Document

Logging Enable

 

 

 

 

 

true/false

true/false

Enable/Disable Prompting for comments

Document

Reason Prompting Enable

 

 

 

 

 

true/false

true/false

Undo

Document

Undo

Undo Action Name

 

 

 

 

 

 

Redo

Document

Redo

Redo Action Name

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Change single cell value

Data

Change Cell

 

R

R

R

R

old value

new value

Paste single cell

Data

Change Cell

 

R

R

R

R

old value

new value

Cut/Clear a block of cells

Data

Clear Block

 

R

R

R

R

 

 

Modify a block of data (e.g. SetCase)

Data

Modify Block

 

R

R

R

R

 

 

 

 

 

 

 

 

 

 

 

 

Paste Block of cells

Data

Paste

 

R

R

R

R

 

 

Fill Random

Data

Fill Random

 

R

R

R

R

 

 

Fill Down

Data

Fill Down

 

R

R

R

R

 

 

Fill Right

Data

Fill Right

 

R

R

R

R

 

 

Standardize Columns/Rows

Data

Standardize Columns [Rows]

 

R

R

R

R

 

 

Transpose Block/File

Data

Transpose

 

R

R

R

R

 

 

 

 

 

 

 

 

 

 

 

 

Change Case Name

Case Specs

Change Case Name

 

R

 

R

 

old value

new value

Change Case Name Length

Case Specs

Change Case Name Length

 

 

 

 

 

old value

new value

Copy Case Names From Var

Case Specs

Change Case Name

Copy from var #

R

 

R

 

 

 

Copy Case Names To Var

Data

Modify Block

Copy From Case Names

R

R

R

R

 

 

Change Case States

Case Specs

Change Case States

 

R

 

R

 

old value

new value

Copy Case States To Var

Data

Modify Block

Copy from Case States

R

R

R

R

 

 

Copy Case States To Var

Case Specs

Change Case States

Copy from Var

 

R

 

R

 

 

Color/Mark By Var

Case Specs

Color/Mark By Category

 

R

R

R

R

 

 

Color/Mark case state variable by var

Data

Color/Mark By Category

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Change Info Box

Headers

Change Info Box

 

 

 

 

 

old value

new value

Change Header

Headers

Change Header

 

 

 

 

 

old value

new value

 

 

 

 

 

 

 

 

 

 

Change Var Name

Var Specs

Change Var Name

 

 

R

 

R

old value

new value

Change Var Type

Var Specs

Change Var Type

 

 

R

 

R

old type

new type

Change Var Length

Var Specs

Change Var Length

 

 

R

 

R

old len

new len

Change MD Code

Var Specs

Change MD Code

 

 

R

 

R

old value

new value

Change Long Name

Var Specs

Change Long Name

 

 

R

 

R

old value

new value

Change text labels

Var Specs

Change Text Labels

 

 

R

 

R

 

 

 

 

 

 

 

 

 

 

 

 

Add Cases

Structure

Add Cases

 

R

 

R

 

 

 

Delete Cases

Structure

Delete Cases

 

R

 

R

 

 

 

Copy Cases

Structure

Copy Cases

Copied N cases after case #

R

 

R

 

 

 

Move Cases

Structure

Move Cases

Moved N Cases after case #

R

 

R

 

 

 

 

 

 

 

 

 

 

 

 

 

Add Vars

Structure

Add Vars

 

 

R

 

R

 

 

Delete Vars

Structure

Delete Vars

 

 

R

 

R

 

 

Copy Vars

Structure

Copy Vars

Copied N Vars after var #

 

R

 

R

 

 

Move Vars

Structure

Move Vars

Moved N vars after var #

 

R

 

R

 

 

 

 

 

 

 

 

 

 

 

 

Change Selection Conditions

Case Selection

Change Selection Conditions

 

 

 

 

 

true/false

true/false

Change Case Weights

Case Weight

Change Case Weights

 

 

R

 

 

true/false

true/false

 

 

 

 

 

 

 

 

 

 

Change Locking

Document

Change Locking

 

 

 

 

 

old flags value

new flags value

Change Event Autorun

Document

Change Events Autorun

 

 

 

 

 

true/false

true/false

Edit Event Code

Document

Edit Event Code

 

 

 

 

 

 

 

Change/Set Event Password

Document

Set Events Password

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Merge Concatenate

Data

Merge Variables Concatenate

2nd file

 

 

 

 

 

 

Merge Cartesian

Data

Merge Variables Cartesian

2nd file

 

 

 

 

 

 

Merge Variables Matching

Data

Merge Variables Matching

2nd file

 

 

 

 

 

 

Merge Text Labels

Data

Merge Text Labels

2nd file

 

 

 

 

 

 

Merge Cases

Data

Merge Cases

2nd file

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sort

Data

Sort

Sort keys+orders

R

 

R

 

 

 

Batch Transform

Data

Batch Transform

the formulas

 

 

 

 

 

 

Recalculate

Data

Recalculate Formulas

 

R

R

R

R

 

 

Rank

Data

Rank

 

 

R

 

R

 

 

Recode

Data

Recode

 

R

R

R

R

 

 

Replace MD

Data

Replace MD

 

 

R

 

R

 

 

Shift

Data

Shift

 

 

R

 

R

 

 

Standardize

Data

Standardize

 

 

R

 

R

 

 

Date Operations - numeric

Data

Numeric Date Conversion

describe op

 

 

 

 

 

 

Date Operations - text

Data

Text Date Conversion

describe op

 

src

 

dest